Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rawmeat
Frequent Visitor

Using dax to unpivot a table

Hi all,

 

I need to unpivot a table. The challenge here is we are using ssas tabular model so I can not just select the target columns and unpivot under "edit query" mode.

The table is like the following:

Value   SJ Time    Penang Time

60         4/18            4/19

50         4/15            4/16

20         4/14            4/15

20         4/15            4/15

10         4/13            4/14 

10        4/20             4/21

The result should look like the following:

Attribute          Value         Time

Penang Time    10             4/14

Penang Time    10             4/21

Penang Time    20             4/15

Penang Time    50             4/16

Penang Time    60             4/19

SJ Time             10            4/13

SJ Time             10            4/20

SJ Time             20            4/14

SJ Time             20            4/15

SJ Time             50            4/15

SJ Time             60            4/18

 

Thanks much

Jason

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Same issue I have.

Somce one suggested UNION function for a question on another website - StackOverFlow

 

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

 

See, If this helps 🙂

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Same issue I have.

Somce one suggested UNION function for a question on another website - StackOverFlow

 

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

 

See, If this helps 🙂

v-yuta-msft
Community Support
Community Support

Hi rawmeat,

 

Are you using live connection mode or import mode? If you are using live connection mode, you can't do changed in your data model so that the "Unpivot Column" is grey and you should do Unpivot operation in your SSAS model. If you are using import mode, you can Unpivot your column by clicking Transform-> Unpivot Column.

 

Hope it's helpful for you.

 

Regards,

Jimmy Tao

Yes the issue here is I am using ssas direct query mode so I can't use edit query option in power bi desktop.

ChrisMendoza
Resident Rockstar
Resident Rockstar

hello @rawmeat,

 

In the query editor > Transform there is a clickable button 'Unpivot Columns'.

4.PNG






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



I see I replied hastily in my last few moments before I got off work on Friday. Forgive me.

 

I am curious to know why having a ssas tabular model has such a limitation. Any explanation or reading that someone could provide would be appreciated.






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.