cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sy898661 Member
Member

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

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 Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
tejaswidmello Established Member
Established Member

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

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

2 REPLIES 2
tejaswidmello Established Member
Established Member

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

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 Member
Member

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

Thank you so much @tejaswidmello , that was just what I needed!! Smiley Happy 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 272 members 2,813 guests
Please welcome our newest community members: