Forum Discussion

Aikeno's avatar
Aikeno
Helper 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
Aikeno's avatar
Aikeno
Helper I
1 year ago

Thanks both for your help !

 

I downloaded the file but in your formula: 

 

= Table.AddColumn(#"Renamed Columns", "Custom", each if [SubRevision] = List.Max(Table.SelectRows(#"Renamed Columns", each [MainID] = _[MainID])[SubRevision])
then "Latest"
else "Old")

 

To which column refers the #"Renamed Columns" ?

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Aikeno ,

In response to your question, #“Renamed Columns” does not refer to a particular column, but rather to the name of the step in the previous operation, which represents the state of the table at the previous stage. Since there is no difference in the names of the columns after separating them according to the punctuation marks, we have performed the Renamed operation, which means that the step before add custom is #“Renamed Columns”, hope this helps you!

 

 

 

 

  • Aikeno's avatar
    Aikeno
    Helper I
    1 year ago

    I am not sure to understand well your answer.

    Here is what i tried and doesn't work.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Aikeno ,
      Can you provide some sample data or related pbix files, this will be more conducive to our analysis of your problem, in order to help you improve the problem faster, look forward to your reply!