Reply
Rena
Resolver I
Resolver I
Partially syndicated - Outbound

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?

 

1 ACCEPTED SOLUTION
ExcelMonke
Super User
Super User

Syndicated - Outbound

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
ExcelMonke
Super User
Super User

Syndicated - Outbound

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Syndicated - Outbound

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

 

DivkLearner
Resolver I
Resolver I

Syndicated - Outbound

Hello @Rena,

 

Are you showing the value on a card visual?

Do you have any filter in the page?

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)