Financial Report structure

Question

Hello,&nbsp;I'm trying to sort a column by an index column, but keep getting an error message:&nbsp;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?&nbsp;

datavitalizer · Answer

Hi&nbsp;swebb&nbsp;Can you provide that sample so I can try it and come back to youDid it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

arul · Answer

swebb&nbsp;,
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/&nbsp;
Thanks,
Arul

swebb · Answer

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

swebb · Answer

Maintenance0Subscription1Total Recurring2License3Services4Other Rev.5Total Revenue6&nbsp;7Accounting8Travel &amp; Ent.9Commission - Partners10Microsoft ISV&nbsp;11Technology12Computer13&nbsp;&nbsp;&nbsp;&nbsp; Software14&nbsp;&nbsp;&nbsp;&nbsp; Dues and Subscr.15&nbsp;&nbsp;&nbsp;&nbsp; Other Technology16

Forum Discussion

Financial Report structure

4 Replies

Related content

Structured Financial Report-Subtotal - Power BI

Table structure

DAX for Financial Year Running Report Employee

ELT JSON / Semi structured

Tweaking Financial Calendar

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