Forum Discussion
Format Check
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!
Create 2 measures:
1. to see if the "." is in place:
dotplace = find(".",'Table'[Column1],1,0)
2. to see if the length exceeds 4 after dotPlacesAfterDot = if(len(mid('Table'[Column1],5,50))>4 || len(mid('Table'[Column1],5,50))<4,1,0)
then apply conditional formatting on the column to get the desired output.
You may need to write additional logics to suit your other possible combination requirements
6 Replies
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.