Forum Discussion
Aixia
2 years agoHelper II
Problem with MinDate and MaxDate
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 2028...
- 2 years ago
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])
amitchandak
2 years agoSuper User
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])
- Aixia2 years agoHelper II