Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |