Sitemap
Blog
- 30.04.2024 - The separation of data and content - why this is the way to go (part 1)
- 09.03.2024 - My favorite windowing function - WINDOW
- 03.03.2024 - Deneb - passing color values as measure value
- 30.12.2023 - Reading and writing JSON files
- 19.12.2023 - Power BI's new Stacked bar chart
- 12.11.2023 - The (better) rectangular pie chart
- 22.10.2023 - Select, Detect, Act, or why I consider Reflex being a watchdog
- 17.10.2023 - Power BI Gateway monitoring and more using Microsoft Fabric
- 09.10.2023 - Tear down walls, no data silos any longer using Microsoft Fabric, and finally, export to Excel will become a breeze
- 24.09.2023 - A song to the unnoticed heroes of every successful Power BI solution - the on-premises data gateway, the vnet gateway, and the sharable cloud connection
- 17.09.2023 - DAX from the trenches - how I write complex DAX statements
- 09.09.2023 - Book Review - the 1st aid kit for the Power BI Sherpa
- 19.08.2023 - Power BI licensing, an eternal mystery, and now - there is also Fabric licensing
- 12.08.2023 - I’ve turned to the dark side (dark, like black velvet), now I’m using a Macbook, or how to connect to a local SQL Server instance that is not that local
- 12.06.2023 - Have data will travel or should I stay or should I go
- 19.03.2023 - Thinking Power Query - M data structures and a not so simple challenge
- 14.12.2022 - Unlock an ample new world by seeing through a window
- 29.05.2022 - Retrieve values from remote tables inside a query step (anonymous function / inline function)
- 16.05.2022 - Field parameters - the dawning of a new era
- 24.04.2022 - Calculated columns and measures
- 23.02.2022 - Extended tables - the sword by my side
- 20.01.2022 - Relationships - the sword(s) of your data model
- 27.12.2021 - Tables, columns, and some things related
- 27.12.2021 - The Power BI data model
- 26.12.2021 - A duration is not the same as datetime!
- 07.12.2021 - Prelude to data modeling
- 02.06.2021 - Using Power Query for Data Sampling
- 13.05.2021 - Data Visualization Challenge - Workout Wednesday 2021 week 19
- 03.04.2021 - Power BI Premium Per User - How to buy
- 03.04.2021 - The pineapple pizza debate, or why pie charts are not that evil
- 28.02.2021 - Object Level Security and Power BI datasets
- 18.01.2021 - Events and projections, using M
- 17.01.2021 - Events and projections
- 03.01.2021 - The Power BI Service Admin - mapping the hive
- 29.11.2020 - The Power BI Service Admin - An Agent of Change
- 02.11.2020 - The previous value
- 22.09.2020 - The dreaded Total in stacked charts
- 13.06.2020 - Power BI, DAX, and relational division - a common search task with a nerdy name
- 04.03.2020 - DAX - Universal truths
- 12.08.2018 - Using svg graphics to create microcharts in Power BI
- 27.07.2018 - Using Power Query to convert an ip4 address into a numeric value
- 06.06.2018 - TopSomething and all the rest called "other"
- 30.04.2018 - Navigating Tabular Tables - Previous Row
- 16.03.2018 - To TREATAS or not to
- 25.02.2018 - What's going on at SQL Konferenz 2018
- 22.02.2018 - What's going on at sqlbits
- 21.02.2018 - Using Table Iterators to calculate a future value
- 21.02.2018 - The weird Year-To-Date calculation
- 21.02.2018 - Analyzing R - with Power BI
- 21.02.2018 - How I got here