ScenarioID(string) | Process(string) | Time(Date) |
---|---|---|
Test | R1 | 1 Jun 2022 1pm |
Test | R1 | 1 Jun 2022 3pm |
Test | R1 | 1 Jun 2022 4pm |
Test | R2 | 2 Jun 2022 1pm |
Test | R2 | 3 Jun 2022 12pm |
I want a filter that looks for the most recent record based on Time for the two columns(Scenario and Process).
The expected result is
ScenarioID(string) | Process(string) | Time(Date) |
---|---|---|
Test | R1 | 1 Jun 2022 4pm |
Test | R2 | 3 Jun 2022 12pm |
Please let me how to add filter in the analysis.