Forum Discussion
LadyCat
3 years agoFrequent Visitor
Two Columns and Multiplication in a Matrix?
Hello, I need help with the following, which I have been battling with for some time. I basically have data that looks like this: The rows in yellow are the most recent transactions...
Ahmedx
3 years agoSuper User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh31YoZm1PBIRbZu_?e=FBlms6
LadyCat
3 years agoFrequent Visitor
Thank you so much for this, it works !
I have another question if you don't mind? How would you handle having the same product reported on the same day but with different amounts and with different costs? I mean the following -
Many thanks