Forum Discussion
Calculated Column with multiple AND & OR
Anonymous try this:
Overall Status = IF( Initiatives[Stage] IN { "Demand Qualification", "G0 Approval", "G1 Approval", "G2 Approval", "G3 Approval", "G4 Approval", "G5 Approval" }, IF( Initiatives[Status] = "0", 1, IF( Initiatives[Status] IN {"1","2"} && Initiatives[Description] = BLANK(). 1, 0 ) ) )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
Showcase Report – Contoso By SpartaBI
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Community ChampionI think because your status column is a text, I'm adding "" around the relevant places in the original messages, you will see this in a minute
You were right with the status code column beeing text.
But still think there are something wrong with you code.
E.g. a project with Initiatives[Stage] = G2 Approval and
Initiatives[Status] = 1 and Describtion BLANK will be assigned with 0
Sorry. It was me messing up with a column name. It seems to work flawlessly! Thanks alot
- SpartaBI
Anonymous my pleasure 🙂
Will appreciate your Kudos 🙂
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543