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 )
This type of thing is perfect for Power Query. Here's the final table I got:
You can see what I did in Power Query and the applied steps.
Here is the file:
Hi, the link to the workbook is invalid. Can you please share again?