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
I have a FY calendar starting from 20230901 and ending on 20280831.
But when I calculated the MinDate and MaxDate for the FY calendar, the MaxDate I got was 20250831, not 20280831.
Did I write the wrong dax measure for it? Or is there another reason for that?
Br/Aixia
Solved! Go to Solution.
@Aixia , measure takes filter, and slicer values and will be restricted by those.
You can Try all to remove the filter context
Maxx(all('Dim Fiscal Calendar'), 'Dim Fiscal Calendar'[Date])
@Aixia , measure takes filter, and slicer values and will be restricted by those.
You can Try all to remove the filter context
Maxx(all('Dim Fiscal Calendar'), 'Dim Fiscal Calendar'[Date])
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.