Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 count result will be 2 (20221414) and 2 (20221420)
this wont show 2 (CR20221417)
please help me the measure
Solved! Go to Solution.
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_777 You can create a new column using below DAX:
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)
Hi @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 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
if 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
@abc_777 you can duplicate the column in Power Query and then remove the CR from the duplicate.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |