-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 54-
(Solution in any language also welcome for Power Query Challenges)
From the transaction table, generate output as shown.
Both Buy and Sell transaction of a product has to be listed for all dates even if transaction has not * happened.
- For ex. for 6/1/22, no Sell transaction in Fruit. But Sell transaction for Fruit will be listed with 0 amount for 6/1/22.
- for 6/1/22, no Buy and Sell transaction in Meat. But Buy as well as Sell transaction for Meat will be listed with 0 amount for 6/1/22.
A Buy transaction causes balance to be increased whereas a Sell transaction decreases the balance.
The dates are in US (MDY) format, so you may need to apply proper transformation as per your locale.
Download Practice File - https://lnkd.in/dTtG-ph5
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r
Excel BI’s LinkedIn Post