Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi Experts
I have a relative date Slicer as shown in the image below, I want to work out the number of days based on what has been selected in the relative date slicer. I have a DimDate table in my model
As shown above my date period is 21/07/2019 to 20/07/2021 show work out the number of days between these too dates... or based on selection
Solved! Go to Solution.
@Anonymous , a measure like this
new measure =
VAR _min = MINX( allselected('Calendar') , 'Calendar'[Date] )
VAR _max = MAXX(allselected('Calendar') , 'Calendar'[Date] )
return
datediff(_min,_max,day) +1
Remove +1 if needed
@Anonymous , a measure like this
new measure =
VAR _min = MINX( allselected('Calendar') , 'Calendar'[Date] )
VAR _max = MAXX(allselected('Calendar') , 'Calendar'[Date] )
return
datediff(_min,_max,day) +1
Remove +1 if needed
Thanks Amit let me test
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.