I have a PowerPivot file where I have Power Query sort by date before entering PowerPivot. Then in Powerpivot I have added calculated columns, a few of which I moved to be in earlier parts of the table instead of the end. However, when I go to Excel, the columns don't match the order that I see in PowerPivot, and the dates are also out of order from Power Query and PowerPivot. Any idea how to fix this or did I overlook something?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Order of Columns and Rows in PowerPivot does not translate to the version on the spreadsheet
Similar threads
- Question
- Solved
