Creating Latest Time Periods Selection from calendar date

[Anonymous]

Is there a way to show Latest 4, 12, 52 and YTD time frames as a dropdown in the report view so the user can select from it ? Here's my Calendar table and the dax I'm trying to do but still not working: 

Thanks for help!

Dax picCalendar date

[Fowmy]

@Anonymous 

The Date Selection code you showed is supposed to be a table, not a column in your date table. you need to go to Modeling Tab > New Table and Paste.

However, you can refer to the below video and adjust as per your need.

https://www.youtube.com/watch?v=AdLDYohLeJc

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Thanks Fowmy. I tried the DAX in table instead of column but still showing #ERROR. Any idea how we can fix this ?

Periods Selection =

VAR LatestDate = MAX('Calendar'[Date])

VAR YearStart = calculate(STARTOFYEAR('ATLAS_Retail Sales'[Week Ending]),YEAR('ATLAS_Retail Sales'[Week Ending])= YEAR(LatestDate))

VAR L12Start = CALCULATE(LASTDATE('ATLAS_Retail Sales'[Week Ending])-84)

VAR L4Start = CALCULATE(LASTDATE('ATLAS_Retail Sales'[Week Ending])-28)

var LWStart = CALCULATE(LASTDATE('ATLAS_Retail Sales'[Week Ending])-7)

VAR L52Start = CALCULATE(LASTDATE('ATLAS_Retail Sales'[Week Ending])-365)

VAR Result =

UNION(

ADDCOLUMNS(

CALENDAR(YearStart, LatestDate),

"Selection","YTD"

),

ADDCOLUMNS(

CALENDAR(L12Start, LatestDate),

"Selection","L12"

),

ADDCOLUMNS(

CALENDAR(L4Start, LatestDate),

"Selection","L4"

),

ADDCOLUMNS(

CALENDAR(LWStart, LatestDate),

"Selection","LW"

),

ADDCOLUMNS(

CALENDAR(L52Start, LatestDate),

"Selection","L52"

)

)

RETURN

Result