Order columns with DAX

[Anonymous]

Good morning,

please l'm using the the DAX function SELECTCOLUMNS to keep two columns from a table. But the problem is that, but the two columns are given in the result in an order that does not suit me. I don't know how to put my two columns in the right order.

Thanks for your help.

Please see below the DAX query used:

TABAbsent1monthJan22InnerJoin = SELECTCOLUMNS( NATURALINNERJOIN(

VAR Tab_TransdateLastMonth= CALCULATETABLE(VS, MONTH(VS[TransDate])=1 && YEAR(VS[TransDate])=2022 && VS[IsDeleted]= "false" && VS[PatientStatus]="Defaulter")

RETURN

SUMMARIZE(Tab_TransdateLastMonth

,VS[BaselineCode], "LastRDVDateCurrent", MAX(VS[TransDate])),

VAR Tab_TransdateLastMonth= CALCULATETABLE(VS, MONTH(VS[TransDate])=12 && YEAR(VS[TransDate])=2021 && VS[IsDeleted]= "false" && (VS[PatientStatus]="On Tx"|| VS[PatientStatus]="Transfered In" || VS[PatientStatus]="Restarted Tx"))

RETURN

SUMMARIZE(Tab_TransdateLastMonth

,VS[BaselineCode], "LastRDVDatePrevious", MAX(VS[TransDate]))

), "BaselineCode", [BaselineCode], "LastRDVDateCurrent", [LastRDVDateCurrent])

The order of the columns in the result is: LastRDVDateCurrent; BaselineCode

But will like to have : BaselineCode; LastRDVDateCurrent

[amitchandak]

@Anonymous , Looking at the summarize in the DAX code Return, BaselineCode should be first. Unless there is something else used.

[Anonymous]

Thanks! It should be first but it isn't 😒

[Anonymous]

Hi @Anonymous,

In fact, the power bi data model tables do not include any row and column index. So the current table column orders are pre-rendered by the power bi data model and they may be changed if any update or change at the backend data loading.
Did you do any changes to your formula? The generated data table structure will be fixed and they not update when you do some small changes. (e.g. change two columns order)

For this scenario, you can backup your formula and manually do some big changes to force update the table structure. 

For example:

change table formula to blank and apply the change, then paste raw DAX formula to force re-active to update table structure.

TABAbsent1monthJan22InnerJoin = {0}

Regards,

Xiaoxin Sheng