Dynamic Period slicer

[BenWatt]

I'm sure I've seen this, but can't track it down.

I'm looking to put a slicer on a report with options YTD, LastMonth, Last 3 months. I would like this to filter the date dimension according to the formula for each one. Is this possible?

as FYI, I've already got relative date logic in to flag each month as "Current Period", "Current Period -1", etc but users want a quicker way to swap between the common filter scenarios.

thanks

[v-ljerr-msft · Accepted solution]

Hi @BenWatt,

You should be able to follow this excellent article which describes how to create Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M to get your expected result. 

Regards