Forum Discussion
Max date not working
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?
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?
3 Replies
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?Those darn filters get me everytime! There was a filter excluding the current month!
