Forum Discussion

yforti's avatar
yforti
Helper 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. ...
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])
)

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
4 years ago

yforti  - I think you can just do as:

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