Slicer for last 12 months

[AndrejZitnay]

Hello all,

I have mulitple data sources and I have all dates merged in date table which links to my Mastercalendar :

MasterCalendar = CALENDAR(MIN('Date Table'[COMPLETIONDATE]),MAX('Date Table'[COMPLETIONDATE]))

MonthNumber = YEAR([Date])*100+MONTH([Date])

MonthYear = FORMAT([Date],"mmm")&"-"&FORMAT([Date],"yy")

I can filter here any months.

I need to create slicer which will fitler last 12 months & anythign older or everything.

Last 12 months option is important for me.

Can you help?

Many thansk.

Kind regards.

Andrej

[v-danhe-msft]

Hi @AndrejZitnay,

Could you have tried with the PREVIOUSQUARTER function? It could Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.

Reference:https://docs.microsoft.com/en-us/dax/previousquarter-function-dax

Regards,

Daniel He

 

[sdjensen]

One approach could be to do as Chris Webb describes in this blog post