Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I need help trying to search for a text in a column and bring back a value due to the error below:
Function 'SWITCH' does not support comparing values of type True/False with values of type Text.
Your help is much appreciated.
Client =
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1 , "Apple", 'Billing and GP'[Client Name] ,
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear", 'Billing and GP'[Client Name],
'Billing and GP'[Client Name]
Solved! Go to Solution.
Try it withouth the second text string. You just need the TRUE part on each line of the SWITCH
Client =
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1 , "Apple",
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear",
'Billing and GP'[Client Name]
)
I think you would be better off using CONTAINSSTRING. That way it will looking the whole string, not just the start and you can simplify it a bit:
Client =
SWITCH( TRUE(),
CONTAINSSTRING('Billing and GP'[Project Name],"Apple"),"Apple",
CONTAINSSTRING('Billing and GP'[Project Name],"Pear"),"Pear",
'Billing and GP'[Client Name]
)
Try it withouth the second text string. You just need the TRUE part on each line of the SWITCH
Client =
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1 , "Apple",
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear",
'Billing and GP'[Client Name]
)
I think you would be better off using CONTAINSSTRING. That way it will looking the whole string, not just the start and you can simplify it a bit:
Client =
SWITCH( TRUE(),
CONTAINSSTRING('Billing and GP'[Project Name],"Apple"),"Apple",
CONTAINSSTRING('Billing and GP'[Project Name],"Pear"),"Pear",
'Billing and GP'[Client Name]
)
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |