Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone,
I seem to be sleeping.. and strugling with something that should be fairly simple. I need to build a conditional column that has to take in values dependent on a combination of existing values in 2 other colums
Column A Column B Column C
TM A NOTOK
TM B Super
TM C Super
MS B Nice
NB C OK
In powerquery i can build
IF column A = MS then Nice else if column A = NB then OK [ but i need here a combination of values:
TM+B or TM+B = Super
TM+A= NOT OK
I can't seem to use "and" with or.. and it is late...maybe a hint will help
Solved! Go to Solution.
This will do all but the "NB" logic, but I think you'll get the idea. You most definitely can use "and" but you cannot use the conditional column builder to do it. You'll need to build your formula manually in a custom column.
= if [Column A] = "MS" then "Nice" else if [Column A] = "TM" and ([Column B] = "B" or [Column B] = "C") then "Super" else if [Column A] = "TM" and [Column B] = "A" then "NOTOK" else null
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThis will do all but the "NB" logic, but I think you'll get the idea. You most definitely can use "and" but you cannot use the conditional column builder to do it. You'll need to build your formula manually in a custom column.
= if [Column A] = "MS" then "Nice" else if [Column A] = "TM" and ([Column B] = "B" or [Column B] = "C") then "Super" else if [Column A] = "TM" and [Column B] = "A" then "NOTOK" else null
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks... I will give it a try.. i hope this was just me sleepy 🙂