Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
dhirendra59
Helper I
Helper I

How to convert cross table

‎05-03-2020 01:54 PM

Please advise how to convert below in PowerBI desktop

DateA BC
4/1/2020230392392
4/2/202039044454
4/3/2020550392454
4/4/20207105465645
4/5/2020870392454
4/6/20201030574448
4/7/20201190392454
4/8/20201350474454

 into something like below

 

HeaderHeaderValues
4/1/2020A230
4/2/2020A390
4/3/2020A550
4/4/2020A710
4/5/2020A870
4/6/2020A1030
4/7/2020A1190
4/8/2020A1350
4/1/2020B392
4/2/2020B44
4/3/2020B392
4/4/2020B546
4/5/2020B392
4/6/2020B574
4/7/2020B392
4/8/2020B474
4/1/2020C392
4/2/2020C454
4/3/2020C454
4/4/2020C5645
4/5/2020C454
4/6/2020C448
4/7/2020C454
4/8/2020C454
Labels:
Message 1 of 4
1,369 Views
0
1 ACCEPTED SOLUTION
edhans
Super User
Super User

‎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

View solution in original post

Message 2 of 4
1,366 Views
3 REPLIES 3
edhans
Super User
Super User

‎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
Message 2 of 4
1,367 Views
dhirendra59
Helper I
Helper I
In response to edhans

‎05-03-2020 02:03 PM

Thank you for quick reply

Message 3 of 4
1,360 Views
0
edhans
Super User
Super User
In response to dhirendra59

‎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
Message 4 of 4
1,355 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All