July 16, 2023In data analysis a common requirement is to compare your values of one week to the ones of the previous…
April 2, 2023If you work in analytics or business intelligence, you are probably already familiar with a date dimension, since almost every…
February 26, 2023Did you ever need to check if a certain text contains a specific value? While this may seem like a…
January 16, 2022In Power BI, slicers generally have OR logic implemented. This I normally also exactly what the user wants to happen.…- October 17, 2021Last week, a colleague at work had an interesting question with a client. They wanted to perform a calculation with…
- January 3, 2021Happy New Year to all my readers! The first challenge this year is the correct calculation of the calendar week.…
- November 13, 2020Update March 2022: Screenshot of the new format pane added Measures are the best way to calculate your key figures…
November 1, 2020If you find a date or datetime format in UNIX format, the first thing you wonder is what it is…- October 6, 2020In my first blog post, I briefly mentioned that my digital notebook - in the form of OneNote - is…
- October 2, 2020If you want to combine several tables, you have to ask yourself whether you should do this already in the…