Forum Discussion

SNad_11's avatar
SNad_11
New Member
3 years ago
Solved

Nested IF/AND Statement Help

Hello everyone, I am trying to find the best way to translate the below excel formula into PowerQuery in PowerBi.    The data is project and date information and essentially the formula looks and c...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi SNad_11 , try this formule: assuming the table is named "Table1"

    Result = if(Table1[% Complete]=1,"Complete",
            if (Table1[Baseline_Date]>Table1[Current Forecast],"On Track",
                if (Table1[Baseline_Date]>TODAY() && Table1[Current Forecast]>Table1[Baseline_Date],"At Risk",
                    if(Table1[Baseline_Date]<TODAY(),"Missed","-"
                    ))))

     Best regards

SNad_11's avatar
SNad_11
New Member
3 years ago

Thanks Bifinity_75! 

 

That worked for me, also have tried this and this worked too: 

if [Percent_Complete]=1 then "Complete"
else if [Baseline_Date]>= [Forecast_Date] then "On Track"
else if [Baseline_Date]>[Today] and [Forecast_Date]>[Baseline_Date] then "At Risk"
else if [Baseline_Date]<[Today] then "Missed" else ""