Financial Report structure

[swebb]

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?

[Arul]

@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

[swebb]

@Arul Thanks for the reply, I've tried this, but with no luck. Same error occurs. 

[othy_bi]

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

[swebb]

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