Creating a MTD/QTD/YTD Time Intelligence Slicer in Power BI
https://www.youtube.com/watch?v=AdLDYohLeJc
Create a new table in DAX 'MTD/QTD/YTD Selection' that has the following rows and columns:
Selection = MTD, QTD or YTD
Rows for every date value in the MTD, QTD and YTD,
User can choose 1 value for Selection (MTD, QTD or YTD).
'MTD/QTD/YTD Selection' has a many-to-1 relationship with the Calendar table.
Comments
Post a Comment