Forum Discussion
Solved
Power Query Editing (Filtering using Table.SelectRows)
Hi All, I'm working on table that I need to filter using the below command. = Table.SelectRows(#"Rename Value and Billing Date", each ([BillT] = "IV" or [BillT] = "ZFR")) I also need to ...
Hi vojtechsima ,
Thank you for the help I was able to figure out after seeing your response. With a few modifications I got it done. Here is the final formula I used. I actually needed tthe or function for each of these filters. Thanks for the help!
= Table.SelectRows(#"Changed Type", each Text.Contains([Material], "EH") or [BillT] = "IV" or [BillT] = "ZFR")
Hi vojtechsima ,
Thank you for the help I was able to figure out after seeing your response. With a few modifications I got it done. Here is the final formula I used. I actually needed tthe or function for each of these filters. Thanks for the help!
= Table.SelectRows(#"Changed Type", each Text.Contains([Material], "EH") or [BillT] = "IV" or [BillT] = "ZFR")