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

creating a table with pivoting multiple columns.

Hi, 

 

Currently, I have the below table and I'm trying to create a new table where I have: 

  • current_arrival_fiscal_year_week in columns across the top
    • SUM(order_qty) for each current_arrival_fiscal_year_week
    • SUM(po_sku_cost) for each current_arrival_fiscal_year_week
  • There would be a row for each sku and store_no.
    • Instead of a row for each sku, store_no and current_arrival_fiscal_year_week.  

slacey7070_0-1624116961223.png

 

The table would look like this, but be a table in the data model. 

slacey7070_2-1624117173410.png

 

I've tried using the pivot column functionality in power query, but it only allows for pivoting one column instead of having both the po_sku_cost and order_qty for each week. Additionally, I've tried a few other ways as well. 

 

After this, I'd be able to join to another table that is aggregated at the sku, store_no level.  

 

Advice would be much appreicated, thanks so much. 

2 REPLIES 2
parry2k
Super User
Super User

@Anonymous not sure why would you like to pivot it. AS a best practice and data modeling practice, the unpivoted table is the way to go. What is the functionality you are not able to achieve the way your current data is?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

The functionality I'm trying to achieve is creating a table that looks like the below. 

 

  • The PO data that I've spoken to in the OP on the right side of the below visual is aggregated at date, sku and location. 
  • The inventory data highlighted in yellow is aggregated at just the sku and location level. 
  • By pivoting the PO data, so I have the weeks in columns, I could then join the Inventory and pivoted PO data on the sku and location columns .

 

slacey7070_0-1624280880824.png

 

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.