Forum Discussion
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 ...
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 "-")
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
Hi Anonymous,
I think this might be missing else instead if comma (,) in this bit:
then "Out of SLA","In SLA".
Kind regards,
John