Forum Discussion
Match() function in DAX?
Does power BI has some sort of match function where I pass a column, a list of values from that column, and put those values as a certain category? For instance, the values from a col called Produtc...
Hi,
You could use the IN operator to do that kind of "match".
In your example the new column could be created with the following DAX statement:
Category =
IF (
'Table'[Products] IN { "Honda", "BMW", "Ferrari"},
"Car",
"Others"
)
Br,
Magnus
is there function equivalent to "IN with wildcard"? for example match x IN { "foo*, fo-o*", "bar"}
Old question, but never answered. I have 1.8 million rows and 1400 distinct values. It simply isn't practical to list them on the command line, not to mention, it's an easy match -- the first two or three characters will get me where I need to be. Awk is looking more promising.
- CONTAINSSTRING might help