Forum Discussion
abc_777
Solution Specialist
Solution Specialisthow to remove first two letter
Hi, I have invoice number like following 20221414 20221415 20221416 20221414 20221414 CR20221417 CR20221417 CR20221418 20221420 20221420 now i want to distinct count, so discinct co...
why you remove CR ? I think you not understand my question.
I want a measure that can count distinct invoice numbers. but not include invoice number starts with CR.
return result will be like this
now i want to distinct count, so discinct count result will be
distinct count= 2 (20221414) and distinct count= 2 (20221420)
no need to count 2 (CR20221417)
abc_777Solution Specialist
Solution Specialistif i remove CR then how i use this CR for other measure. I also need this CR for other measure not want to remove parmanently. I want to create measure to remove cr for a specific measure and then distinct count
