Forum Discussion

yforti's avatar
yforti
Icon for Helper II rankHelper II
4 years ago
Solved

Help with calculated dates.

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

Need Help
Tips and Tricks
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    4 years ago

    yforti  - I think you can just do as:

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

2 Replies

  • twentyninefifty's avatar
    twentyninefifty
    Frequent Visitor
    4 years ago

    Output can be a table?

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

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    yforti  - I think you can just do as:

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