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.
Hi,
I am working with very limited data and I am trying to delete some duplicate data in a column but without removing the row. In the case I am working on, I don't have the line item price, only the total value of the PO on each line. If I were to group or remove duplicated, I lose the other rows, but I want to keep that information for my visuals.
Here's an example of that I am trying to do
Customer | PO | Item purchased | Total PO $ | >> | Customer | PO | Item purchased | Total PO $ |
ABC Inc | 123456 | 123456 | $ 100.00 | ABC Inc | 123456 | 123456 | $ 100.00 | |
ABC Inc | 123456 | 234567 | $ 100.00 | ABC Inc | 123456 | 234567 | ||
ABC Inc | 123456 | 345678 | $ 100.00 | ABC Inc | 123456 | 345678 | ||
ABC Inc | 456789 | 456789 | $ 333.00 | ABC Inc | 456789 | 456789 | $ 333.00 | |
ABC Inc | 456789 | 678912 | $ 333.00 | ABC Inc | 456789 | 678912 | ||
XYZ ltd. | 987654 | 987654 | $ 250.00 | XYZ ltd. | 987654 | 987654 | $ 250.00 | |
XYZ ltd. | 987654 | 654321 | $ 250.00 | XYZ ltd. | 987654 | 654321 | ||
XYZ ltd. | 321987 | 321987 | $ 1,000.00 | XYZ ltd. | 321987 | 321987 | $ 1,000.00 | |
XYZ ltd. | 321987 | 876543 | $ 1,000.00 | XYZ ltd. | 321987 | 876543 | ||
XYZ ltd. | 321987 | 765432 | $ 1,000.00 | XYZ ltd. | 321987 | 765432 |
Thank you for any help 🙂
What is your data source? Is it Excel?
User | Count |
---|---|
82 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
97 | |
86 | |
68 |