Forum Discussion

Aixia's avatar
Aixia
Helper II
2 years ago
Solved

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...
  • amitchandak's avatar
    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])