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