Forum Discussion
Solved
latest date column needed
Hi all, I need help with data . I have table with id and date data. I need a column with latest date if the id service id completed date 101 6/20/2024 101 5/10/2023 102 10/10/2023 ...
Latest Completed Date = CALCULATE ( MAX ( 'Table'[completed date] ), ALLEXCEPT ( 'Table', 'Table'[service id] ) )
Latest Completed Date =
CALCULATE (
MAX ( 'Table'[completed date] ),
ALLEXCEPT ( 'Table', 'Table'[service id] )
)