Forum Discussion
Running total
Hi , i have small issue with running total. Im calculating stock value in warehause from 2022 till today, and its working. For quantities vorking with no mistake, but for value not. Pro...
if you have more simple solution... then you are my best friend 😄
problem is that i must track stock value on weekly base of each material.
then material group... procurment type.. supplier..
lot of demands from my manager.
this is only solution that work for me.
plus i need every type of movement in other calculation..
well i cant help out much without seeing datasets but if you just want to get the stock vlue per week , powerbi automatically does that
your measure above will sum up all values until today example if yesterday i had 10$ and today i had 30$ the measure will return
10 on yesterday and 40 on today if you just want to return the price per day just use a simple max function