CODEWITHSUNDEEP
powerbidaxpowerquery
Serdia
Serdia

Reputation: 4428

How to create Trailing 12 month date parameter in Power BI

Is it possible to create trailing 12 month date parameter? I want to be able to choose Month-Year, so it display data till the end of that chosen Month-Year 12 months back.

Something like that on a picture below.

Do I need to create some date measures for that?

Thanks

enter image description here

Upvotes: 0

Views: 3880

Answers (1)

Mike Honey
Mike Honey

Reputation: 15027

I would use the Relative Date slicer & filter feature built into Power BI. It can cater to that requirements E.g. Last - 12 - Months (Calendar)

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-slicer-filter-date-range/

No modeling preparation is needed - it is set in the report page design.

Upvotes: 4

Related Questions