Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm trying to sort a column by an index column, but keep getting an error message:
As far as I can tell I don't see any duplicates. I've done the remove duplicates and it only got rid of my null/blank spaces. Keeping the structure and order is important to the end user. Any advice?
@swebb ,
Please check this blog post, I hope it will help you.
https://excelfort.com/power-bi-tip-how-to-sort-a-column-with-duplicates-by-another-column/
Thanks,
Arul
@Arul Thanks for the reply, I've tried this, but with no luck. Same error occurs.
Hi @swebb
Can you provide that sample so I can try it and come back to you
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
Maintenance | 0 |
Subscription | 1 |
Total Recurring | 2 |
License | 3 |
Services | 4 |
Other Rev. | 5 |
Total Revenue | 6 |
7 | |
Accounting | 8 |
Travel & Ent. | 9 |
Commission - Partners | 10 |
Microsoft ISV | 11 |
Technology | 12 |
Computer | 13 |
Software | 14 |
Dues and Subscr. | 15 |
Other Technology | 16 |
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |