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...
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