Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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"
)
)