Forum Discussion
Solved
Custom Column or Measure?
My very first question, new to Power Bi. I am trying to find the way to create new measure or new column called "NewProduct" using text values from the existing column. So I tried to use simple If st...
Hi Mk60,
I'd recommend you to check the SWITCH function.
You could do something like this:
In plain text:
Calculated Column = SWITCH ( TRUE (), [Value] IN { "CC-20b", "CC-50b", "CC-50d", "CC-50n" }, "Product A", [Value] IN { "83", "888", "98", "CC-75" }, "Product B", BLANK () )Best Regards,
Alexander
So happy to receive my very first reply with a great DAX suggestion that worked for me! Thanks so much, Alexander! Greatly apprecite your time and consideration to respond to a brand new user 🙂
Hi Mk60,
I'd recommend you to check the SWITCH function.
You could do something like this:
In plain text:
Calculated Column =
SWITCH ( TRUE (),
[Value] IN { "CC-20b", "CC-50b", "CC-50d", "CC-50n" }, "Product A",
[Value] IN { "83", "888", "98", "CC-75" }, "Product B",
BLANK () )
Best Regards,
Alexander
So happy to receive my very first reply with a great DAX suggestion that worked for me! Thanks so much, Alexander! Greatly apprecite your time and consideration to respond to a brand new user 🙂