Forum Discussion
Solution Specialisthow to remove first two letter
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)
Super Userabc_777 You can create a new column using below DAX:
Solution Specialistwhy 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)