Reply
Topic Options
- 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

How to convert cross table
05-03-2020
01:54 PM
Please advise how to convert below in PowerBI desktop
Date | A | B | C |
4/1/2020 | 230 | 392 | 392 |
4/2/2020 | 390 | 44 | 454 |
4/3/2020 | 550 | 392 | 454 |
4/4/2020 | 710 | 546 | 5645 |
4/5/2020 | 870 | 392 | 454 |
4/6/2020 | 1030 | 574 | 448 |
4/7/2020 | 1190 | 392 | 454 |
4/8/2020 | 1350 | 474 | 454 |
into something like below
Header | Header | Values |
4/1/2020 | A | 230 |
4/2/2020 | A | 390 |
4/3/2020 | A | 550 |
4/4/2020 | A | 710 |
4/5/2020 | A | 870 |
4/6/2020 | A | 1030 |
4/7/2020 | A | 1190 |
4/8/2020 | A | 1350 |
4/1/2020 | B | 392 |
4/2/2020 | B | 44 |
4/3/2020 | B | 392 |
4/4/2020 | B | 546 |
4/5/2020 | B | 392 |
4/6/2020 | B | 574 |
4/7/2020 | B | 392 |
4/8/2020 | B | 474 |
4/1/2020 | C | 392 |
4/2/2020 | C | 454 |
4/3/2020 | C | 454 |
4/4/2020 | C | 5645 |
4/5/2020 | C | 454 |
4/6/2020 | C | 448 |
4/7/2020 | C | 454 |
4/8/2020 | C | 454 |
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2020
02:01 PM

In Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
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!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2020
02:01 PM

In Power Query, select the date column, then on the Transformation ribbon, select "Unpivot Other Columns."
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!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2020
02:03 PM

Thank you for quick reply
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2020
02:05 PM

Glad to help @dhirendra59
Mark it as a solution if it has answered the question so others know this is the solution if they are looking later.
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!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-14-2023 05:59 AM | |||
10-02-2023 07:00 AM | |||
08-12-2024 09:16 AM | |||
01-18-2024 04:15 AM | |||
03-31-2023 11:49 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |