If you use DAX to flatten Parent-Child hierarchies you will end up with a table that has a static number of columns (like described here). If you need a dynamic (…) Read more
Posts Tagged ‘DAX’
Dynamic duration calculation using DAX in Power BI and Power Pivot
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
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
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
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