Forum Discussion

M_Butler's avatar
M_Butler
Frequent Visitor
2 years ago
Solved

Power Query - Pivoting Data

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 co...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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

M_Butler's avatar
M_Butler
Frequent Visitor
2 years ago

Amazing, thank you so much!

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Happy to help 🙂