Forum Discussion
If OR in a data model
Hi I'm trying to recreate this in power BI I figured out how to do it in excel but just coming up against roadblocks.
=IF(OR(B2="SSAS",B2="BOB",B2="ARF",B2="AMRF"),IF(OR(C2="Leap elite",C2="Leap elite - REGULAR"),TRUE,FALSE))
I need to add an additional column to the model to output thre or false.
Try
IF((B2="SSAS" || B2="BOB" || B2="ARF" || B2="AMRF"),IF((C2="Leap elite" || C2="Leap elite - REGULAR"),TRUE,FALSE),False)Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
1 Reply
Try
IF((B2="SSAS" || B2="BOB" || B2="ARF" || B2="AMRF"),IF((C2="Leap elite" || C2="Leap elite - REGULAR"),TRUE,FALSE),False)Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601