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 )
