Advanced Editor - Filtering Columns

Hi Anonymous,

Based on my test, we can add an if condition in Advanced Editor to check if the value of Company parameter is All. There is an example for your reference.

let

    Source = Table.Combine({Table1, Table2}),

    appendtable = Source,

 

    #"Filtered Rows" = Table.SelectRows(Source, each [Company] = Company),

    result= if Company = "All" then appendtable

    else #"Filtered Rows"

in

#"result"

Through that we can get the result as below:

For more information, please refer to the pbix as attached.

https://www.dropbox.com/s/v7hbk2mrh2s1z8o/Advanced-Editor-Filtering-Columns2.pbix?dl=0

Your code can be updated as below.

let

Source = Table.Combine({Contact1, Contact2, Contact3, Contact4, Contact5, Contact6, Contact7, Contact8}),

    appendtable = Source,

 

    #"Filtered Rows" = Table.SelectRows(Source, each [Company] = Company),

    result= if Company = "All" then appendtable

    else #"Filtered Rows"

in

#"result"

Regards,

Frank