Max Date / Period for dates in a list/table

[rpinxt]

I do not understand why I am aaalways strugling with these things 😞

Could somebody teach me the correct way for these thing to always work??

MaxPeriod should everywhere be 10-2023.

Why is my measure nog working in this case?

[rpinxt]

Thanks @Ahmedx ,

But not entirely what I need:

It now find the latest date in the future.

[Ahmedx · Accepted solution]

change this to the date columns from the sales table

CALCULATE(
MAX(SALES[Date]),

REMOVEFILTERS())

[rpinxt]

Yes this did the trick.

Thanks.

So I guess it will not work with the date from the autocalendar.

[Ahmedx]

pls try this

CALCULATE(
MAX(dimDate[Priod]),

REMOVEFILTERS())