Forum Discussion
Solved
Filter if contains
Hi All, While filtering having some issues. M: = Table.SelectRows(#"Renamed Columns1", each ([Progress] <> 1 and Text.Contains([ID],"A"))) Error: Expression.Error: We cann...
Hi kassymov_su ,
Since columns Progress and ID are of different datatype and you have used in the same M query code line, you are receiving that error.
Bifurcating it into 2 different steps should resolve this:
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Progress] <> 1)),//For Progress NOT EQUALS 1 #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each not Text.Contains([ID], "A")) // FOR ID NOT CONTAINS "A"PFA .pbix with solution. You can go to advanced editor and check.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Hi kassymov_su ,
Since columns Progress and ID are of different datatype and you have used in the same M query code line, you are receiving that error.
Bifurcating it into 2 different steps should resolve this:
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Progress] <> 1)),//For Progress NOT EQUALS 1
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each not Text.Contains([ID], "A")) // FOR ID NOT CONTAINS "A"PFA .pbix with solution. You can go to advanced editor and check.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |