cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ahmedelshark
Helper I
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
amitchandak
Super User
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)

View solution in original post

3 REPLIES 3
Bhavana832
New Member

@amitchandak 

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?

 

Thank you in adavance

amitchandak
Super User
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)

This worked. Thank you @amitchandak !

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.