Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
5 years ago
Solved

Power Query Group By

Hello, I am transforming a bunch of PDF files and I get to the point where I need to extract the last table of each file. I tried to use Group By by the max of column "LastTable"   But its n...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    It's not as efficient, but you can do it in a single filter step like this

     

    = Table.SelectRows(
      #"Prev Step",
      (x) => x[LastTable]
          = List.Max(
                Table.SelectRows(#"Changed Type", each [Name] = x[Name])[LastTable]
            )
  )

     

    It's doing essentially the same thing, i.e., checking if [LastTable] equals the maximal [LastTable] index over the sub-table that has a matching [Name].

PC2790's avatar
PC2790
Community Champion
5 years ago

Hi Fcoatis ,

 

Did you try Advanced grouping based on 'Name' and 'Data' columns and then creating a new column with Operation as Max and column as Last Table?

It should give you the records having the maximum MaxTable value in the specific category.

If this doesn't work for you or your requirement is not purposed, please share Power BI file removing all the sensitive data if any.