Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
Im trying to create a new column based on 3 queries? I basically want to say if it contains this then bring back that:
So if it contains 123 its Test1, 456 its Test 2 else Test 3
NewColumnName =
IF(
'NewColumnName'[SERVICE_TYPE] = 123,
"Test1",
IF(
'NewColumnName'[SERVICE_TYPE] = 456,
"Test2",
"Test3"
)
)
Thanks in advance
Solved! Go to Solution.
Try this:
NewColumnName =
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE], "123"),
"Test1",
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE],"456"),
"Test2",
"Test3"
)
)
Amazing, thank you!
You're welcome @dommyw277 🙂
I would also suggest you to use SWITCH instead of nested IFs:
NewColumnName =
SWITCH(TRUE(),
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE], "123"),"Test1",
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE],"456"),"Test2",
"Test3")
What is the type of the column SERVICE_TYPE? Is it Text or Numeric? If it is text you are treating it as a numeric.
Hi, yes its Text - it contains text and numbers?
Thanks. Heres a brief example:
cd6b6eec- Azure
0b4c205 - AZURE 2
Try this:
NewColumnName =
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE], "123"),
"Test1",
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE],"456"),
"Test2",
"Test3"
)
)
User | Count |
---|---|
82 | |
78 | |
67 | |
46 | |
45 |
User | Count |
---|---|
105 | |
44 | |
39 | |
39 | |
39 |