Nested if in PowerBI- Power Query

[Anonymous]

Hi Guys,

Reaching out for help. I'm new in using PowerBI and with PowerQuery.
I'm trying to bring this nested if function that I have used in GSheets:

Here's the table

Column U	Column A	Column AB	Column R
Pending Hold	179.9	12	8/23/2022
New	38.7	8	7/02/2022

The new column should be containing:

Column U	Column A	Column AB	Column R	SLA
Pending Hold	179.9	12	8/23/2022	Out of SLA
New	38.7	8	7/02/2022	Out of SLA

I've tried using try otherwise and calculate function, I'm having a hard time to get it running

Thank you in advance

[Anonymous]

I actually figure out already what's wrong with code, I actually state a wrong column name for ColumnAB, @wdx223_Daniel's code did work, thank you so much @jbwtp  as well

Thank you guys 

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"SLA",each let a=if [ColumnA]>[Column AB] then "Out of SLA","In SLA",b=Date.From(DateTime.LocalNow()),c=if [ColumnU]<>"Pending Hold" then a else if [ColumnR]=b then "Due Today" else if [ColumnR]<b then "Out of SLA Pending Hold" else "Future Follow Up Date" in try c otherwise "-")

[Anonymous]

Hi @wdx223_Daniel,

Thank you for providing a solution, however, it's giving me a Expression.SyntaxError: Token Eof expected,

can't figure where I went wrong 

[jbwtp]

Hi @Anonymous,

I think this might be missing else instead if comma (,) in this bit:

then "Out of SLA","In SLA".

Kind regards,

John

[jbwtp]

a bit more structured, and maybe esier to read:

= Table.AddColumn(PreviousStep,"SLA",each 
        if [Column U]<>"Pending Hold" 
        then
            if [Column A]>[Column AB]
            then "Out of SLA" 
            else "In SLA"
        else
            if Date.From([Column R], "en_US")=Date.From(DateTime.LocalNow())
            then "Due Today"
            else 
                if Date.From([Column R], "en_US")<Date.From(DateTime.LocalNow())
                then "Out of SLA Pending Hold" 
                else "Future Follow Up Date")