Creating a WTD/DAY time intelligence slicer in desktop

[chavanr]

Hi there,

I am creating a time intelligence slicer for YTD/MTD/WTD & DAY calculation.

Wondering if anyone could help with the WTD & DAY calculation

Please find below calculation for YTD & MTD.

Dynamic Date Scope =

VAR TodayDate = TODAY()

VAR YearStart = CALCULATE(STARTOFYEAR('Dates for Trends'[MMM YYYY]),YEAR('Dates for Trends'[MMM YYYY]) =YEAR(TodayDate))

VAR MonthStart = CALCULATE(STARTOFMONTH('Dates for Trends'[MMM YYYY]),YEAR('Dates for Trends'[MMM YYYY]) = YEAR(TodayDate),MONTH('Dates for Trends'[Month Year]) =MONTH(TodayDate))

VAR Result=

UNION(

ADDCOLUMNS(

CALENDAR(YearStart,TodayDate),

"Selection", "YTD"

),

ADDCOLUMNS(

CALENDAR(MonthStart,TodayDate),

"Selection","MTD"

)

)

RETURN

Result

[amitchandak · Accepted solution]

@chavanr , I have blog and video for YTD, QTD, MTD, WOW/WTD, and DOD

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[chavanr]

thanks @amitchandak !!