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