Forum Discussion

anshusaketsingh's avatar
anshusaketsingh
Frequent Visitor
1 year ago

REGEXP_MATCH replication in DAX

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 creat...
FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi anshusaketsingh ,

 

try to add a calculated column like:

column =

CONTAINSSTRING(

[Error_Message],

"PowerBI_needs_to_support_Regexp"

)

anshusaketsingh's avatar
anshusaketsingh
Frequent Visitor
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.