Help with calculated dates.

[yforti]

Hi guys,

I need help to calculate only the last date by NR_RESERVA:

For example, the expected result for the number AFC10000055 is: 11/04/2022 because this is the last date for this key number.

I need it in the measure or in the column. So the model needs to calculate the last date for each key number

[ChrisMendoza · Accepted solution]

@yforti  - I think you can just do as:

Measure = 
CALCULATE(
    MAX(TableName[Date]),
    ALLEXCEPT(TableName,TableName[Group])
)

[twentyninefifty]

Output can be a table?

Try summarize NR_RESERV and then lastdate(date) for the second column.