Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |