Forum Discussion

ceciliam2's avatar
ceciliam2
New Member
3 years ago
Solved

Selectcolumns not working properly

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 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      ceciliam2
      New Member
      3 years ago

      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? 🙂