Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |