The best Power Query and M documentation – Introducing PowerQuery.how
March 11, 2024A good documentation is essential in order to work efficiently in IT. Sometimes a software manufacturer does a good job…
Easy week over week comparison in Power BI with the new OFFSET function
July 16, 2023In data analysis a common requirement is to compare your values of one week to the ones of the previous…
Remove rows that exist in another table in Power Query – How to use an Anti-Join (Not-In-Join) for data cleansing in Power BI
April 16, 2023When you're preparing your data in Power Query, you might come to the point where you have to exclude rows…
The ultimate guide to date table relationships – understand relationships with a date column, an integer column and “mark as date table” in Power BI correctly
April 2, 2023If you work in analytics or business intelligence, you are probably already familiar with a date dimension, since almost every…
One-step conditional value replacement in a column in Power Query
March 13, 2023When you're working a lot with Power Query, you will sooner or later have to replace values in a column,…
Check if a text contains a specific value in DAX
February 26, 2023Did you ever need to check if a certain text contains a specific value? While this may seem like a…
How to block other people from overriding your dataset in Power BI (and why you might not want to do that)
February 20, 2023When you publish a dataset on the Power BI service, anyone with the proper access to it can make changes…wtFact-February is coming! Get ready for my 20 best short Power BI tips!
January 29, 2023It's almost February and in the next days I will start a small series on LinkedIn.On every weekday, I will…
How to create a service principal for power bi
August 12, 2022I will show you, how you can easily create an Azure service principal for Power BI!
Persisting temporary accessible data via Power BI Datamarts with the example of Power BI Activity Logs
July 10, 2022You can persist temporary accessible data like the Power BI Activity Logs only with Power BI Tools! With Power BI…