Calculate ISO 8601 week in DAX with hidden parameter

January 3, 2021
Denis Selimovic
DAXcomment 3Created with Sketch Beta.0 comments

Happy New Year to all my readers! The first challenge this year is the correct calculation of the calendar week. Because this year we have again the case that the calendar weeks differ between America and Europe. Different calculation of the calendar week between North America and Europe While in North America the first week…

Read more

Power BI Composite Model V2 – the missing part between Self-Service and Goverened BI is in Preview

December 20, 2020
Denis Selimovic
Data modelcomment 3Created with Sketch Beta.0 comments

Normally, I write about updates in the Power BI universe quite rarely, and when I do, it’s only when it’s a significant improvement from my perspective. So it is in this case.Last week, Microsoft introduced in Preview the ability to access Power BI datasets and Azure Analysis Services via DirectQuery. What doesn’t sound all that…

Read more

Tip for your daily work – Do you already know Microsoft PowerToys and the Color Picker?

December 5, 2020
Denis Selimovic
Othercomment 3Created with Sketch Beta.0 comments

Today I’ m going to write a post that doesn’t directly have anything to do with Power BI, but still adds a lot of value there. For about a year now, I’ve been using Microsoft PowerToys, a combination of different tools that make your life easier. Original idea, FancyZones to divide the screen into different…

Read more

Display DAX Measures in a Matrix on Rows

November 13, 2020
Denis Selimovic
Data visualization, DAXcomment 3Created with Sketch Beta.2 comments

Update March 2022: Screenshot of the new format pane added Measures are the best way to calculate your key figures in Power BI. In a matrix, however, these can normally only be displayed as values and not at row or column level. However, sometimes you need them exactly at the row level. Display contribution margin…

Read more

Integrate Power BI Report with complete interactivity in OneNote

November 8, 2020
Denis Selimovic
Data visualizationcomment 3Created with Sketch Beta.0 comments

I recently received a tip from a colleague at work, which was also something I hadn’t seen before. More precisely, it was about integrating a Power BI report with all reporting options into a OneNote page. For this purpose, I use the report with the manual fonts as an example. The report has to be…

Read more