Selectcolumns not working properly

[ceciliam2]

Hi guys,

This problem has been puzzled me for a couple days and I didn't find similar post here or anywhere. So I decided to post myself. 

I want to re-order a dax table's columns, but selectcolumns doesn't retrun columns in the order I set. WHY is it acting like this? Has anyone run into the same problem before? 

Thanks!

Cecilia 

[amitchandak · Accepted solution]

@ceciliam2 , Take out the script(dax code), Drop the table, create again, and try. if you change the script after the table is created it does not follow the order

[ceciliam2]

thanks amit. it worked. unfortunately i had to rewrite all the measures and relink relationships after i drop the dax table in my live model. I wonder why selectcolumns works like this, or maybe it's a bug that can be fixed? 🙂