Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.