Months between first date of relative slicer and today

[Anonymous]

I need to use the number of months between the first date in a relative date slice and today.

So for this slicer I need the number 3

 

[MFelix · Accepted solution]

Hi @Anonymous,

Use a measure like this:

Number of months =
DATEDIFF ( MIN ( Table[date] ); TODAY (); MONTH )

The column refered in Minimum function should be replace by the column on your slicer.

Regards,

MFelix