Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have this data:
Date | Product | Volume |
8/04/2024 | A | 10 |
8/04/2024 | B | 20 |
9/04/2024 | A | 10 |
9/04/2024 | C | 30 |
10/04/2024 | A | 5 |
I would like to use Power Query to convert it into this format:
Date | A | B | C |
8/04/2024 | 10 | 20 | 0 |
9/04/2024 | 10 | 0 | 30 |
10/04/2024 | 5 | 0 | 0 |
I have tried using transpose/unpivot but I am not getting the desired results unfortunately.
Any ideas? TIA!
Solved! Go to Solution.
Hi @M_Butler
You need to pivot the column product :
after this replace null with 0
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @M_Butler
You need to pivot the column product :
after this replace null with 0
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Amazing, thank you so much!
Happy to help 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |