Forum Discussion

MagikJukas's avatar
MagikJukas
Resolver III
3 years ago
Solved

Table.Select multi conditions

Hi, I have a table that I am trying merge into the same table with some specific conditions   Table contains: Father Components Level Index First I merged based one into the other: = Table...
Need Help
  • MagikJukas's avatar
    MagikJukas
    3 years ago
    = Table.AddColumn(#"Merged Queries", "Custom", each Table.SelectRows([MergedTable], 
    (Magic) => 
    (Magic[Index]<[Index]) and 
    (Magic[Level]=([Level]-1))))
MagikJukas's avatar
MagikJukas
Resolver III
3 years ago
= Table.AddColumn(#"Merged Queries", "Custom", each Table.SelectRows([MergedTable], 
(Magic) => 
(Magic[Index]<[Index]) and 
(Magic[Level]=([Level]-1))))