Forum Discussion
Solved
Retrieve last entry by group
Hi there, I hope that you are able to help me with my problem. In the example table below, I am trying to calculate Column D where I’d like to display the latest “Process Date” (Column C) for...
No worries. You can just add the filter on Category back in after the ALLEXCEPT
Final Date = CALCULATE ( MAX ( Project[Process Date] ), ALLEXCEPT ( Project, Project[Project ID] ), //Removes all contexts/filters except for Project ID Project[Category] = "Rock" //Adds back in a filter on category )
No worries. You can just add the filter on Category back in after the ALLEXCEPT
Final Date =
CALCULATE (
MAX ( Project[Process Date] ),
ALLEXCEPT ( Project, Project[Project ID] ), //Removes all contexts/filters except for Project ID
Project[Category] = "Rock" //Adds back in a filter on category
)
Hi David,
Thank you very much for the solution! It works exactly as required.