Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Rena
Resolver I
Resolver I

Max date not working

‎12-03-2024 07:31 AM

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?

 

Labels:
Message 1 of 4
141 Views
0
1 ACCEPTED SOLUTION
ExcelMonke
Super User
Super User

‎12-03-2024 07:40 AM

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

Message 3 of 4
130 Views
3 REPLIES 3
ExcelMonke
Super User
Super User

‎12-03-2024 07:40 AM

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!



Message 3 of 4
131 Views
Rena
Resolver I
Resolver I
In response to ExcelMonke

‎12-03-2024 07:48 AM

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

 

Message 4 of 4
117 Views
DivkLearner
Resolver I
Resolver I

‎12-03-2024 07:38 AM

Hello @Rena,

 

Are you showing the value on a card visual?

Do you have any filter in the page?

Message 2 of 4
113 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All