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.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |