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 hig...
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
luapdoniv
Resolver II
Resolver III would suggest, create a new view and filter out for that dimension to "Not contain" "."
- luapdoniv
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
- luapdoniv
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