Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filtering nested groups - Power Query M

Hi All, I am having trouble filtering the column [Source] within my nested group table "Grouped". My condition should check whether the value "SAT" exists in the column, if true it will remove rows...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    if List.Contains([Grouped][Source],"SAT") then Table.SelectRows([Grouped],each [Source] <> "VBRP") else [Grouped]

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try this

if List.Contains([Grouped][Source],"SAT") then Table.SelectRows([Grouped],each [Source] <> "VBRP") else [Grouped]

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you so much!