Forum Discussion
Create column throught measure
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.
Community ChampionYou 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.
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
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.
Thank you all!!
v-lili6-msftCommunity Support
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