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)
Community ChampionHi abc_777
1. Go into Power Query via Transform Data on main ribbon.
2. Click on the respective Invoice Number column in Power Query.
3. Go to Replace Values.
4. Input CR into Value To Find like below. Press ok.
Done! Hope this helps 🙂
abc_777if 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