Reply
Regular Visitor
Posts: 18
Registered: ‎10-11-2018
Accepted Solution

Create column throught measure

Hi all, 

 

It's possible create one column throught one measure?

 

Thank you.

 

VC


Accepted Solutions
Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

Re: 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.

2018-10-16_17-56-52.png

 

 

 

View solution in original post


All Replies
Super User
Posts: 10,536
Registered: ‎07-11-2015

Re: Create column throught measure

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Regular Visitor
Posts: 18
Registered: ‎10-11-2018

Re: Create column throught measure

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

Community Support Team
Posts: 1,352
Registered: ‎07-30-2018

Re: Create column throught measure

hi, @VanessaCasaca22

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

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

Re: 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.

2018-10-16_17-56-52.png

 

 

 

Regular Visitor
Posts: 18
Registered: ‎10-11-2018

Re: Create column throught measure

Thank you all!!