Forum Discussion

AdamDevis's avatar
AdamDevis
New Member
8 years ago
Solved

IF Function

Looking for help with this.  Here is the formual I wrote: Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>10,"Alert",""), if(TransfersBI[BOL Status]="In Transit",IF([D...
Need Help
  • BKirsch12's avatar
    BKirsch12
    8 years ago

    Had some time to write the code:

     

    Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>15,"Priority",if([Days in Transit]>10,"Alert","")),"")
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    AdamDevis,

     

    You may add SWITCH Function as well.

    Column =
IF (
    TransfersBI[BOL Status] = "In Transit",
    SWITCH (
        TRUE (),
        [Days in Transit] > 15, "priority",
        [Days in Transit] > 10, "Alert"
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

AdamDevis,

 

You may add SWITCH Function as well.

Column =
IF (
    TransfersBI[BOL Status] = "In Transit",
    SWITCH (
        TRUE (),
        [Days in Transit] > 15, "priority",
        [Days in Transit] > 10, "Alert"
    )
)