Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to Solution.
@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)
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
@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)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.