Forum Discussion
Compare values with if statement
I have a table with multiple fields and my main concern is 2 fields, one has ID and the other has grade (numerical field). I am trying to check first id ID to ID match in the same field and if they...
Hello, you could use a if else in Power Query M, here's a sample code
= Table.AddColumn(#"Previous Step", "OutputColumnName", each if ( ( [#"ID1"] = [#"ID2"] ) and ( [#"GradeValue"] > YourValue ) ) then 1 else 0)