The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
13 | |
8 | |
8 |