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] ) )
Hi Ashik008 - you can use max function on completed date and filter based on ID with current id.
Calculated columns as below:
LatestCompleteDate =
VAR CurrentServiceID = ServiceData[service id]
RETURN
CALCULATE(
MAX(ServiceData[completed date]),
FILTER(
ServiceData,
ServiceData[service id] = CurrentServiceID
)
)
Report view:
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
rajendraongole1 hi sir ,can you share the pbix file for it. formula not working for ,me