Forum Discussion

Aikeno's avatar
Aikeno
Icon for Helper I rankHelper I
1 year ago

Filter only with most recent ID

Hello everyone,   I want to filter on a criteria ID by the most recent revision. Exemple below, I have J5.11.a and J5.11.b and I want to keep only the one with the most recent revision here J5.11....
Need Help
Selva-Salimi's avatar
Selva-Salimi
Icon for Solution Sage rankSolution Sage
1 year ago

Hi Aikeno 

 

you can write a column in your table as follows:

 

 if (max('Table'[version])='Table'[version] , 1 ,0)
 
and then simply add this column to visual filter pane and set it to 1.
 
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.