Max date not working

[Rena]

I have a very simple measure:

MAX ('LEDS'[Fiscal Week])

When I first put this measure in, it worked perfectly and returned 11/18/2024.  However, I have refreshed the data each week after, bringing in newer data, and the date returned in the measure is not changing.  

Currently, the max date should be 12/2/2024 but it is still returning 11/18/2024.  Why isn't it recalculating?

[ExcelMonke · Accepted solution]

Hello @Rena , 
Just curious, have you confirmed that the underlying data table has the latest dates (up to 12/2/2024) and / or are there any filters interacting with your measure?

[Rena]

Those darn filters get me everytime!  There was a filter excluding the current month!

[DivkLearner]

Hello @Rena,

Are you showing the value on a card visual?

Do you have any filter in the page?