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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Weeks with amounts in columns

Hi,

 

I'm currently working on a dataset with an another layout that I'm used to.

Normaly I've got the weeks sorted in the rows, as below;

 

Pbra_0-1649180478384.png

But for now, the weeks are spread over the columns, as below;

 

Pbra_1-1649180667858.png

For example, how am I going to process the total sales of the Porsche Taycan? And how can I make a sum of the total sales?

 

Questions, questions, questions...

 

Cheers!

 

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

Select the first 2 columns, right click and click on "Unpivot Other Columns".  You will now see the Table as you see in image 1.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Anonymous
Not applicable

Hi @Anonymous ,

 

Transform data.

vcgaomsft_0-1649393732015.png

Select column [Brand] and column [Model] -> right click and click Unpivot Other Columns -> Close and apply.

vcgaomsft_1-1649393853493.png

vcgaomsft_2-1649394099410.png

Attach the PBIX file for reference. Hope it helps.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous ,

 

Transform data.

vcgaomsft_0-1649393732015.png

Select column [Brand] and column [Model] -> right click and click Unpivot Other Columns -> Close and apply.

vcgaomsft_1-1649393853493.png

vcgaomsft_2-1649394099410.png

Attach the PBIX file for reference. Hope it helps.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

 

Ashish_Mathur
Super User
Super User

Hi,

Select the first 2 columns, right click and click on "Unpivot Other Columns".  You will now see the Table as you see in image 1.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
truptis
Community Champion
Community Champion

Hi @Anonymous ,

Try to Pivot your table. Once you Pivot it you will get the desired structure and then you can calculate Sales based upon Brand. 

 

@Anonymous if this helps you, then please hit the thumbs up. Thanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.