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
dhirendra59
Helper I
Helper I

How to convert cross table

Please advise how to convert below in PowerBI desktop

DateBC
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
1 ACCEPTED SOLUTION
edhans
Super User
Super User

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

3 REPLIES 3
edhans
Super User
Super User

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

Thank you for quick reply

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

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.