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