topic Re: REGEXP_MATCH replication in DAX in DAX Commands and Tips

REGEXP_MATCH replication in DAX

anshusaketsingh — Thu, 21 Nov 2024 20:56:24 GMT

So I recently found out Regexp is not supported by Power BI. I wonder why would they not put anything as powerful as that in PowerBI.

Anway, this has put me in a situation where I am unable to create a logic in Power BI for below logic in Tableau

CASE
REGEXP_MATCH([Error_Message],'.*PowerBI_needs_to_support_Regexp.*') Then TRUE
END

The above expression means that

.= any character except newline
*=Any number of occurrences (including 0 occurrences)

Any suggestion how to do that in PowerBI without using Python or R?

Re: REGEXP_MATCH replication in DAX

FreemanZ — Thu, 21 Nov 2024 21:21:05 GMT

hi anshusaketsingh ,

try to add a calculated column like:

column =

CONTAINSSTRING(

[Error_Message],

"PowerBI_needs_to_support_Regexp"

)

Re: REGEXP_MATCH replication in DAX

anshusaketsingh — Fri, 22 Nov 2024 06:56:38 GMT

I am not looking for substring funtion , I am looking a way to check if first character is a character and then there are numbers only before substring begins, a containstring won't do that

Re: REGEXP_MATCH replication in DAX

Anonymous — Mon, 25 Nov 2024 03:33:14 GMT

Hi anshusaketsingh ,

According to your statement, I think your requirement is to achieve your goal like regular expression in Power BI Desktop.

As far as I know, Power BI doesn't support this function directly. However you can try Python Script to do this.

Please refer to below blog to learn more details.

Using regular expressions in power bi desktop - Microsoft Fabric Community

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.