- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Unpivot columns using dax
Hi there,
I've created a table using data from an imported table and since I've created this table using DAX, I can't manipulate it in the power query editor. I'd like to unpivot all the columns I've created, is there a way to do this using DAX?
I created my table using selectcolumns, and created 38 columns.
Thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
A simple example. Hope this is helpful.
Table 2 =
VAR t1 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store1", "Value", [Store1] )
VAR t2 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store2", "Value", [Store2] )
VAR t3 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store3", "Value", [Store3] )
RETURN
UNION ( t1, t2, t3 )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
A simple example. Hope this is helpful.
Table 2 =
VAR t1 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store1", "Value", [Store1] )
VAR t2 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store2", "Value", [Store2] )
VAR t3 =
SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store3", "Value", [Store3] )
RETURN
UNION ( t1, t2, t3 )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , I would suggest to better do what you did in DAX to create that table in power query and use unpivot there.
Anyways refer dax way
https://www.youtube.com/watch?v=9Xv8COs59tc
https://community.powerbi.com/t5/Desktop/Using-dax-to-unpivot-a-table/td-p/421116
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for your reply. I understand that it is much easier to unpivote a large table using power query editor, however my table does not show in the editor as I've created it using the new table button.
How can I go about creating a new table so that I'm able to edit it in power query?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-29-2024 03:00 PM | |||
11-13-2023 09:09 AM | |||
03-13-2024 05:30 AM | |||
11-21-2023 03:15 AM | |||
04-17-2019 06:53 AM |
User | Count |
---|---|
117 | |
99 | |
84 | |
53 | |
47 |