Forum Discussion
Joachim2108
Helper I
Helper IUsing 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"
AntrikshSharma
Community Champion
Community ChampionJoachim2108 Wildcards are not supported in DAX afaik, you will have to use either
https://dax.guide/containsstring/
or
Joachim2108Helper I
Helper IIf I can't use wildcards, could I combine the SWITCH statement with a LEFT statement?