Forum Discussion

Dayna's avatar
Dayna
Helper V
4 years ago
Solved

Power Query - Filtering with brackets (and / or combined filter)

Hello,   I'm struggling a little with the syntax on this one, within Power Query, how do you filter using a combined search or and / or?    What I want to do is:   Filter records where curr1 = ...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    remove the 2nd 'each'

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create a conditional column with your conditions and use that column to filter the data.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcncKUNJRcg0NUorViQbTCF5eaU4OkAtSAuJClMJ4EKVgXiwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Curr1 = _t, Curr2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Curr1", type text}, {"Curr2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Filter", each if [Curr1]  =  "GBP" and [Curr2]  = "EUR" then "Filter"
else if [Curr1]  = "EUR"  and [Curr2]  =  "GBP" then "Filter" else null)
in
    #"Added Custom"