Forum Discussion

MatthewMcL's avatar
MatthewMcL
Frequent Visitor
8 years ago
Solved

Reordering Table Columns in DAX/ Outside of Query Manager

Hello,   I have three tables that I had created outside of the Query Editor, through "New Table" (Calculated Tables). I have calculated columns here that I created using DAX. Now that I have these ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    MatthewMcL,

     

    To get the table as requested, we can use SELECTCOLUMNS Function (DAX) to reorder columns. For example:

    Table =  UNION(SELECTCOLUMNS(State1, Name1, Field1, Name2 , Field2…), SELECTCOLUMNS(State2, Name1, Field1, Name2, Field2…)…)

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

MatthewMcL,

 

To get the table as requested, we can use SELECTCOLUMNS Function (DAX) to reorder columns. For example:

Table =  UNION(SELECTCOLUMNS(State1, Name1, Field1, Name2 , Field2…), SELECTCOLUMNS(State2, Name1, Field1, Name2, Field2…)…)

LC_Health's avatar
LC_Health
Regular Visitor
3 years ago

This is a terrible way to do things, especially when I'm calculating tables with lots of columns.
It would be a nice interim fix if you could add an argument to UNION() that lets you match on column name instead of just column order. Considering that you cannot realisticly change column order a lot of the time, you could at least make sure the column names match and go from there.