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

Bifinity_75's avatar
Bifinity_75
Solution Sage
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