New notation for Date or DateTime format in Power BI

August 14, 2021
Denis Selimovic
Uncategorizedcomment 3Created with Sketch Beta.0 comments

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…

Read more

Change formatting of each individual value dynamically with Calculation Groups

July 27, 2021
Denis Selimovic
Calculation Groups, Data modelcomment 3Created with Sketch Beta.2 comments

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…

Read more

My Power BI and Power Query code snippets are moving to GitHub

July 15, 2021
Denis Selimovic
Blogcomment 3Created with Sketch Beta.0 comments

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…

Read more

Add a single value parameter for any column

July 4, 2021
Denis Selimovic
Data modelcomment 3Created with Sketch Beta.0 comments

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…

Read more

Why is it sometimes not possible to select the exact number in the what-if parameter and how can this be solved?

June 27, 2021
Denis Selimovic
Data modelcomment 3Created with Sketch Beta.7 comments

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…

Read more