While it is fairly easy to calculate the difference between 2 dates in DAX using DATEDIFF, it is a bit more demanding if you want to exclude weekends and holidays (…) Read more
Posts in Category ‘Power Pivot’
Analyzing events with a duration in DAX – further simplification
Alberto Ferrari has recently published a very smart concept how to analyze events with a duration in DAX, which you should read here, if you haven’t done yet. It simplifies (…) Read more
Import Measures from different Tabular Models using DAX Editor
Marco Russo has created a great tool for SSAS tabular that lets you edit measure definitions (which you should read here first if you haven’t done yet). In this article (…) Read more
Easy Profit and Loss and other (account) scheme reports in Power BI and Power Pivot using DAX
This is about an easy way to create typical finance reports like Profit and Loss using DAX that (unlike all other solutions I’ve come across so far) can be handled with (…) Read more
How to hack yourself in Power BI (and Power Pivot?)
Reading Gerhard Brueckl’s post on how to visualize SSAS calculation dependencies reminded me of my post about a similar technique from December last year. His solution has features that would do (…) Read more
Visualize dependencies between your DAX measures: DAX-VizArt-Wizard
This DAX-VizArt-Wizard vizualizes dependencies between your DAX measures, shows the definition of all related measures and shows differences between the measures of 2 models/versions. This works for Power Pivot, Power BI (…) Read more