Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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 🙂
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 41 | |
| 36 | |
| 32 |