Create column throught measure

[Anonymous]

Hi all, 

It's possible create one column throught one measure?

Thank you.

VC

[Greg_Deckler]

You can use ADDCOLUMNS to add columns to a table but that's really internal to a measure or in a DAX table creation formula. If you are trying to use a Measure to add a column to an existing table, that's not really how it works.

[Anonymous]

Hi @Greg_Deckler,

Thank you for your response.

My objetive it was create one column throuht one measure beacause like my data are by live connection, i can't create costum columns. 

For exemple, I have a hour column and i want sort this column by other column (a column that corresponce a hour 00:00 a 1, hour 01:00 a 2 and sucessively).

You know any form the help me?

Thank you.

VC

[Anonymous · Accepted solution]

Not sure if this workaround could help you.

You can add this hour column and the sort by column into a visual table in report page and then sort the column.

[Anonymous]

Thank you all!!

[v-lili6-msft]

hi, @Anonymous

You need to sort this in SSAS model itself as live connection does not have the ability to use this feature.

Best Regards,

Lin