Filter based on two columns

Q&A
,
1
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.

2

A pivot table will work. You can make Processing a 2nd layer row, and apply max, or any other aggregation to the columns.

3

Hi, @akash_sambrekar. Did @Andy_Brand’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!