Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Nested if in PowerBI- Power Query

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 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
jbwtp
Memorable Member
3 years ago

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's avatar
    jbwtp
    Memorable Member
    3 years ago

    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")