Excel Power Query Nested If

[RICH937]

Hi Excel People!
I tried my first nested "if/then" in PQ today, but am only getting "D" as a response. Can someone help me understand why? I pulled a similar formula from excel off the grid: Power Query If statement: nested ifs & multiple conditions Here's mine:
= Table.AddColumn(#"Reordered Columns1", "Custom", each if [COLUMN NAME A ]="TRUE" then
if [#"COLUMN NAME B FROM MERGE"]="TRUE" then "A" else "C"
else
if [#"COLUMN NAME FROM MERGE)"]="TRUE" then "B"
else "D")
==>all results in my PQ editor are "D"

In excel this would be: if([@column name]=true, if([@column name b]=true, "A","C"), if([@column name b]=true, "b", "d")

Any help in what I did wrong would be greatly appreciated!

Thank you!

 

[smozgur]

You are using text instead of boolean for comparison. If the mentioned column values are boolean, then you should user true and false instead of "TRUE" and "FALSE".
Could you please try the following instead?

Table.AddColumn(#"Reordered Columns1", "Custom", 
        each 
            if [COLUMN NAME A ]=true then
                if [#"COLUMN NAME B FROM MERGE"]=true then "A" else "C"
            else
                if [#"COLUMN NAME FROM MERGE)"]=true then "B"
            else "D"
        )

 

[RICH937]

arrrrrgh! thank you. The True/False values were drawn from a conditional formula column with the results in all caps. PQ didn't recognize TRUE or FALSE unless I added the "TRUE" and "FALSE". I swapped to the lowercase, and it's working perfectly. That's what I get for being hyper vigilant on text case in PQ!

 

[smozgur]

arrrrrgh! thank you.

You're welcome. Glad to hear it helps.