New notation for Date or DateTime format in Power BI
Quick update on the Power BI August 2021 release and this more, in case you encounter this new spelling and wonder what it is.As the title suggests, there is a new way to create a Date or DateTime value. If we consider the CALENDAR function as an example, then two values in the format Date…
Change formatting of each individual value dynamically with Calculation Groups
In September last year I had already written an article on how to dynamically adjust the values of a measure, for example in millions, thousands or without scaling: Dynamic scaling of a measure in Power BI with DAX The approach at that time with the FORMAT function had a big disadvantage, the value is always…
My Power BI and Power Query code snippets are moving to GitHub
Pretty much since I started the blog, I’ve been gradually sharing my code snippets for DAX and M here on the website. As the list got longer and longer and more and more confusing with all the examples, I decided to maintain and publish the code snippets on GitHub from now on. There I can…
Add a single value parameter for any column
Last week I had investigated why a what-if parameter sometimes skips values and how to bypass this. In a discussion with my valued friend Bernat Agulló, we came across the topic of single values in slicers and he directed me to a tweet on how to do this with Tabular Editor. Single values as slicer…
Why is it sometimes not possible to select the exact number in the what-if parameter and how can this be solved?
I like working pretty much with the what-if parameter in Power BI. With the help of this, it is possible to run through corresponding scenarios in a very fine-grained manner. What would my operating result look like if I can increase my sales by a factor of 2? How would it look with 1.5? And…