Forum Discussion
Solved
Create Conditional Column Based Upon Two Other Columns
Edited to clarify the columns I'm comparing are not text True/False, but numbers 0/1 in case that makes a difference. I'm trying to create a new conditional column in Power Query where the new co...
pls try this code
Logical.From( Number.From([A])*Number.From([B]))
You can nest them in the IF like this
= Table.AddColumn(Source, "Custom", each if [Column A] = "TRUE" then if [Column B] = "TRUE" then "TRUE" else "FALSE" else "FALSE")
This didn't work, but I just realised that my true/false is actualy 0/1, so number instead of text. Not sure how/if that changes anything.
