Main column in calculated table moved on its own

[Anonymous]

I have a very curious case that thankfully does not have much of a practical effect, as PBI does not care about column order, but it does bother me on a visual level.

I have a calculated table with a distinct(union(values(... structure pulling info from some other tables that are imported from a data source.

But for some reason, that main column has suddenly moved from its default left-most positon - where it should be - to a position four columns to the right, so in the middle of the data that is pulled from the referenced other tables.

I tried to find out how to move columns in a table, but all I found refers to modifying the order through "transform data" - and that is not applicable to calculated tables.

I was even trying to find out where the table structure gets saved inside the pbix file itself, but I couldn't find the file where the order is saved either.

Any ideas?

[amitchandak]

@Anonymous , if you created dax column, then went back to power query and do some changes and add a column, then the position can also change

[Anonymous]

@amitchandakI did add some columns later on as I updated the structure, but why would BI move the DAX column from its default position on the very left?

[V-lianl-msft]

Please vote for this.https://ideas.powerbi.com/ideas/idea/?ideaid=a272113a-0f44-41ac-a402-bf1066984cda 

DAX columns do not support fixing to a special position until you use DAX to create a new table.

NewTable =
SELECTCOLUMNS (
    OldTable,
    "Column1", OldTable[Column1],
    "Column2", OldTable[Column2],
    "Column3", OldTable[Column3]
)

[Anonymous]

I find it ridiculous that something so simple is still not implemented. Currently the base column for my table sits right in the middle of the data it pulls from other tables, it's stupid.