Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 between 100-900 (e.g. 112, 320 etc.). I want to group these into smaller categories.
In plain english I want for example: if the ProductGroup starts with 3, i.e. is between 300-399 (data type = text), it needs to be categorised as "Tools". I used wilcard characters in the DAX query, however it doesn't seem to recognise them. A piece of the query is below - what am I doing wrong? Thanks in advance!
ProductCategory=
SWITCH ( TRUE (),
'Storage’[ProductGroup] = "3**", "Tools",
'Storage’[ProductGroup] = "4**", "Service",
'Storage’[ProductGroup] = "5**", "Transport",
"Other" )
Solved! Go to Solution.
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"
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?
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |