Need some clarrification on Relative Date Slicer

[MKM]

Hi Team,

Please check and give me details on the Relative Date Slicer.

If we select last 2 month In this Slicer how we can select only "May ". how we can select selective past month, kindly check and do the needful

[v-yanjiang-msft · Accepted solution]

Hi @MKM ,

It can't be achieved directly in relative slicer, here's my workaroud:

Create a measure as below:

Measure =
IF ( DATEDIFF ( MAX ( 'Table'[Date] ), TODAY (), MONTH ) = 2, 1, 0 )

Put it in the visual filter and select show items when the value is 1.

After click apply filter, get the correct result:

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

If you pick a particular month it is no longer a relative selection.