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.
Hello all,
I'm trying to create a check to ensure that users are entering the Billing Entity in the correct format, which is always 3 letters, dot, 4 numbers; ie BDA.5468
Is therea way to highlight any records where the billing entity does not match this format? I don't have access to the Edit Queries in this dataset, so would have to be a column.
Thanks!
Solved! Go to Solution.
Create 2 measures:
1. to see if the "." is in place:
I would suggest, create a new view and filter out for that dimension to "Not contain" "."
If you are expecting entire formats to change, could you share a sample source data, so that I can work it out and see. Thanks.
It varies quite a bit as I believe the field is free text, so the first three are correct and then the rest are examples of errors:
BDA.4856
GHS.2586
CPT.1854
GHE.4586_NAME_OF_COMPANY_UNDERSCORES
1238
LPT.8675 NAME OF COMPANY NO UNDERSCORES
Create 2 measures:
1. to see if the "." is in place:
Thank you!
You are welcome and hope your problem got resolved. Let me know if you need any further help. Cheers!
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |