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…
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…
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…
Change your slicer easily from OR to AND logic in Power BI
January 16, 2022In Power BI, slicers generally have OR logic implemented. This I normally also exactly what the user wants to happen.…Use measure or virtual table as filter for CALCULATE
October 17, 2021Last week, a colleague at work had an interesting question with a client. They wanted to perform a calculation with…Calculate ISO 8601 week in DAX with hidden parameter
January 3, 2021Happy New Year to all my readers! The first challenge this year is the correct calculation of the calendar week.…Display DAX Measures in a Matrix on Rows
November 13, 2020Update March 2022: Screenshot of the new format pane added Measures are the best way to calculate your key figures…
Convert UNIX Timestamp to DATE or DATETIME format in Power BI
November 1, 2020If you find a date or datetime format in UNIX format, the first thing you wonder is what it is…My frequently used Power BI snippets
October 6, 2020In my first blog post, I briefly mentioned that my digital notebook - in the form of OneNote - is…Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX
October 2, 2020If you want to combine several tables, you have to ask yourself whether you should do this already in the…