Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I need help with this file. I need to group all of the part numbers together so that it only reads one part number but then have a column that reads how many times that PN came up.
Like this
PN Count
000-110-006 3
003-001-006 1
00861-0556-0001 9
Many thanks!
Solved! Go to Solution.
Hi @baBI123
If you drag your Part Number field to the values area of your table visual twice, you can set the properties of one of the fields to be a count of...
Hi @baBI123
If you drag your Part Number field to the values area of your table visual twice, you can set the properties of one of the fields to be a count of...
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |