Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AOD
Helper II
Helper II

Validate the pattern in string

Hi All,

 

Need help in validating a specific string pattern in the field.  Can you please advice on how can this be achieved in DAX? Thanks.

Rule is as below

1st - Letter        
2nd - Letter/ digit
3rd - Space/ digit
4th - Space/ digit
5th - Space/ digit/ Letter              
6th - Letter/ digit
7th – Letter

 

1 REPLY 1
amitchandak
Super User
Super User

@AOD , where is the pattern missing?

 

In power query, we can use Text.Contains to search

https://docs.microsoft.com/en-us/powerquery-m/text-contains

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors