Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to convert a tableau solution to Power BI and am ready to slam my computer against a wall. It seems that everything is harder than it needs to be.
I simply want to produce an "A" or "B" result based on a whole set of and/or conditions. Simple in Tableau or SQL but I can't make it work in Power BI / DAX. Open to any suggestions:
Here's what it looks like in Tableau - how do I do this in power BI??
IF ( [Employed] = 'F'
and (
([Current Status]) ='A'
OR ([Current Status]) ='B'
OR ([Current Status]) ='C'
OR ([Current Status]) ='D'
OR ([Current Status]) ='E'
))
OR
( [Employed] = 'T'
and (
([Current Status]) ='G'
OR ([Current Status]) ='H'
OR ([Current Status]) ='I'
OR ([Current Status]) ='J'
))
OR (([Current Status] ='E' and [Naics]<>'92'))
then 'BAD' else 'GOOD' END
Any help would be GREATLY appreciated!
Solved! Go to Solution.
Hi @TomGee ,
I'm assuming you are making a calculated column, try the following code:
Column = SWITCH ( TRUE (), Table[Employed] = 'F' && Table[Current Status] IN { 'A', 'B', 'C', 'D', 'E' }, "Bad", Table[Employed] = 'T' && Table[Current Status] IN { 'G', 'H', 'I', 'J' }, "Bad", Table[Current Status] = 'E' && Table[Naics] <> '92', "Bad", "GOOD" )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @TomGee ,
I'm assuming you are making a calculated column, try the following code:
Column = SWITCH ( TRUE (), Table[Employed] = 'F' && Table[Current Status] IN { 'A', 'B', 'C', 'D', 'E' }, "Bad", Table[Employed] = 'T' && Table[Current Status] IN { 'G', 'H', 'I', 'J' }, "Bad", Table[Current Status] = 'E' && Table[Naics] <> '92', "Bad", "GOOD" )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |