Forum Discussion
Solved
Using wildcard characters in a SWITCH function
Hi! I'm struggling to create a new collumn with wildcard characters, based on certain values in another collumn using the SWITCH function. The products in the original collumn are grouped bet...
Hi all, the solution turned out to be:
IF (LEFT ( Storage[Productgroup) = LEN(1)) = "3", "Tools",
IF (LEFT ( Storage[Productgroup], LEN(1)) = "4", "Service",
IF (LEFT ( Storage[Productgroup], LEN(1)) = "5", "Transport"
Joachim2108 Wildcards are not supported in DAX afaik, you will have to use either
https://dax.guide/containsstring/
or
If I can't use wildcards, could I combine the SWITCH statement with a LEFT statement?