Forum Discussion
DAX to filter tables by regular expression
Hello, I have following DAX code where I simply filter table gl by another table 'Sheet1' and sum values from gl: Actuals = CALCULATE(SUM('public gl'[movement]),FILTER(ALL('public gl'[gl_code],...
If you really want to have something like a regex matcher in DAX... well, you can forget it. There's no such thing in DAX. DAX has a very simple string pattern matching mechanism that is not even on par with the SQL LIKE operator, so any even unsophisticated pattern matching is not possible.