Can you rearrange calculated columns in imported table view?

[djkoenig]

Hello Experts,

I think the answer is essentially no, but is there a way to rearrange the columns in table view, specifically calculated columns?

Example: 

I'd like to move the 'Total Fee Rate' next to the 'Fee Fixed Rate'. I cannot do so in Power Query as it is a calculated column. Also, I don't want to use the SELECTCOLUMNS function and reorder that way, since, well, its time consuming and I've created a whole other table (data size, maintennace, etc.). 

Is there a workaround? And if not, could someone explain the difficulty to implementing? 

Thanks!

[djkoenig]

Thanks @vicky_ ! I have added my vote. 

And I saw that Stack post. The issue is that calculated columns still wouldn't display in PowerQuery, so while that is a nifty way to reorganize your data, I don't think its applicable everywhere. I appreciate it though, just seems it's a blood from rock scenario (nigh impossible). 

[vicky_ · Accepted solution]

There is no real way to re-order the column, but there is an idea you can upvote - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a272113a-0f44-41ac-a402-bf1066984cda

There might be a work-around by removing your columns in PowerQuery, loading and re-loading data. Check the second solution here: https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi