cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
adim Frequent Visitor
Frequent Visitor

DAX pivoting table

Hi there,

 

I have this table in my model: 

 

provider_idyeartimesamplerate
id12011123
id22011456
id32011789
id12012111213
id22012141516
id32012171819
id12013212223
id22013242526
id32013272829

 

and I need to get this result table:

 

  2011  2012  2013 
provider_idtimesampleratetimesampleratetimesamplerate
id1123111213212223
id2456141516242526
id3789171819272829


Is there any chance to achieve this through DAX? 

 

Thank you for your time.

 

Adrian

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX pivoting table

Hi @adim,

 

Nope, dax is impossible to achieve this.
In my opinion, you can use original table column to create matrix visual with same result.

12.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX pivoting table

Hi @adim,

 

Nope, dax is impossible to achieve this.
In my opinion, you can use original table column to create matrix visual with same result.

12.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |