is there a way to do this with an OR function?

[sy898661]

Hi all!

I have this calculated column that shows a little stop character if x conditions are met:

Planned Ship FORMAT = 

IF(AND('board-Query'[STEP30 Plan Completion Date] > RELATED('board-Sheet'[Planned Ship Date]), ISBLANK('board-Query'[STEP30 Actual Completion Date]) ), UNICHAR(9940), "")

Is there any way to add another condition, that is the same as this but for STEP40, into this that says if the conditions for STEP30 OR STEP40 are met, add the unichar ... so like this:

Planned Ship FORMAT = 

IF(AND('board-Query'[STEP30 Plan Completion Date] > RELATED('board-Sheet'[Planned Ship Date]), ISBLANK('board-Query'[STEP30 Actual Completion Date]) ), UNICHAR(9940), "") 

OR 

IF(AND('board-Query'[STEP40 Plan Completion Date] > RELATED('board-Sheet'[Planned Ship Date]), ISBLANK('board-Query'[STEP40 Actual Completion Date]) ), UNICHAR(9940), "")

Thank you 🙂

[Anonymous · Accepted solution]

Hi @sy898661 

you can give this a try

IF(AND('board-Query'[STEP30 Plan Completion Date] > RELATED('board-Sheet'[Planned Ship Date]), ISBLANK('board-Query'[STEP30 Actual Completion Date]) 
||
IF(AND('board-Query'[STEP40 Plan Completion Date] > RELATED('board-Sheet'[Planned Ship Date]), ISBLANK('board-Query'[STEP40 Actual Completion Date])),
UNICHAR(9940),""))

check for extra parenthesis if any.

Thanks,

Tejaswi

[sy898661]

Thank you so much @Anonymous , that was just what I needed!! 🙂