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 !

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors