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 20280831.

    

Did I write the wrong dax measure for it? Or is there another reason for that?

 

Br/Aixia

  • 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])

2 Replies

  • 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])