Get rows with most recent quarter by grouping values in another column

[Mukesh_s]

Hi Everyone, I am trying to get the rows with recent Quarter for each value in col 1.

Example I have data as below

Col 1	Col 2
A	2022Q1
A	2022Q4
B	2023Q1
B	2022Q2

I want to get the data as below with 

Col 1	Col 2
A	2022Q4
B	2023Q1

Thanks in advance.

[henrikalmen]

Try a table with dimension [Col 1] and measure maxstring([Col 2])