cancel
Showing results for
Did you mean:
Helper I

## Card Visual to display number of months from date range slicer

Hello,

I am trying to write a measure that will display the total number of months between the two dates in my date range slicer. How do I refer to the slicer itself? Or if there is a better way do this, please let me know.

Thank you so much in advance.

1 ACCEPTED SOLUTION
Super User

@Ahmedelshark , Create a new measure

diff between selected range =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
datediff(_min, _max, month)

3 REPLIES 3
New Member

Hi Sir,

I am also searching on the same issue that time i found your solution , I have tried but finding an error. Could you please help me with this.

if starting date is 01-04-2022 & ending date is 31-08-2022, According to your formulae it will show 4 months in between but actually its 5(apr,may, june, july, august)

How can we solve this?

Super User

@Ahmedelshark , Create a new measure

diff between selected range =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
datediff(_min, _max, month)

Helper I

This worked. Thank you @amitchandak !