Forum Discussion

Bish92's avatar
Bish92
Frequent Visitor
4 years ago
Solved

Multiple If Statements

Hi, I need help converting an Excel Formula for it to work in Powerbi... The statement is the following... =IF([@[PROMISE_DATE]]="","On Time", IF(AND([@[COMMIT TO SHIP]]<TODAY(), [@[PROMISE_DATE]]...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Bish92 

    You can try this, change the part in the rectangle

    On Time/Late = IF('Table'[PROMISE_DATE]=BLANK(),"On Time",IF('Table'[COMMIT TO SHIP]<TODAY() && 'Table'[PROMISE_DATE]<TODAY(),"Late", IF('Table'[COMMIT TO SHIP]<='Table'[PROMISE_DATE],"On Time","Late")))

    FYI: DAX operators - DAX | Microsoft Docs

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

HotChilli's avatar
HotChilli
Community Champion
4 years ago

It's easier to debug an IF statement by breaking it down into separate clauses - so you can identify which part is throwing the error.

For now, let's test out the first clause by creating a test column:

IF([@[PROMISE_DATE]]="","On Time", "Late")

I think that will probably throw an error, because a date is being compared to a string, You can test a date against BLANK() instead.

Let me know how it goes