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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi SNad_11 ,

 

Whether the advice given by Bifinity_75  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry