Using MAX(Date) to filter out latest date is not working

[amestrian]

I created a calculated column with the following calculation:

last_day=IF(Table[Date]=max(Table[Date]),1,0) 

and applied a filter to all pages to not use Last_day = 1.

I just refreshed the data (and got more days) and the column shows last_day = 1 for 03 Apr 2022, when 04 Apr 2022 is actually the latest date in the sample. 

Also, even if the filter is there I can still see the data point for 3 Apr in my timeseries plots... 

I've read all posts regarding Max(Date) but I haven't seen this issue before. 

Any thoughts?

Why is this calculation suddenly failing? 

[amitchandak]

@amestrian , Hope the calculation is like this and there was was a typo in what you shared

last_day=IF(Table[Date]=max(Table[Date]),1,0)

Just check if the date has timestamp ,if yes,  then try like

last_day=IF(datevalues(Table[Date])= datevalues(max(Table[Date])) ,1,0)

[amestrian]

@amitchandak 

Indeed that was a typo. Corrected it in the first post for visibility.

The Date variable is in date datatype, not datetime. The format is "03 April 2022".

I still tried your solution and no luck, the column still returns a 1 for 03 April 2022 instead of 04.

[v-shex-msft]

Hi @amestrian ,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng