Relative Date Filter

[schoden]

Hi Community, 

Why am I not getting month number as  1, 2, 3, 4 or -1, -2, -3  beyound or before Current month 0.

The DATEDIFF in the column is specified as MONTH still I am getting Days 

[amitchandak · Accepted solution]

@schoden , I am assuming that is a column and you are aggregating it visual

Try a measure

Measure = datediff(Min(Date[Date]) , Today(), Month)

or

Measure = datediff(Max(Date[Date]) , Today(), Month)

[schoden]

@amitchandak  Yes it is column , as I need to give user the flexibilty in a slicer to choose the month number to go back or forward.

In a measure We can't put in slicer.

[amitchandak]

@schoden , I am confused. In a column, we can not use a slicer. In measure, we can.

Or you do not want to use slicer?

[schoden]

Thanks @amitchandak  as awalys .. I changed the data category as MAX/ MIN and worked.

Yes as a slicer shown in Pic is what I wanted.