Forum Discussion
Visualization: stock differences between days
Hi there,
I have a database with products (quantity in stock) and their changes in time and I need a graph with differences between days.
The table can look like this:
I don't know how to calculate differences between days (in the picture is shown just two days but there will be each day of a month) and visualize them.
I will really appriciate any help. Thanks a lot!
DB structure
Hi Jaromir,
You could create calculated measure for "Total sales to previous date":
Prev Sales = CALCULATE(SUM(Sales[Sales]),PREVIOUSDAY(Sales[Date]))
Create calculated measure for stock differences between days:
stock differences between days = sum(Sales[Sales])- [Prev Sales]
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri Nguyen
5 Replies
Hi Jaromir,
What is meaning of differences between days, could you show me 1 example for that logic? so i could understand it correctly.
Hi,
I basically need to calculate a difference in stock amount for a selected product_id between two consecutive dates.
Say the stock amount on Feb 1 is 43, on Feb 2 it is 38. I need to add a column which would calculate that the difference in stock between those two days is -5. And I need to do the same for every row (date).
Thanks!
Hi Jaromir,
You could create calculated measure for "Total sales to previous date":
Prev Sales = CALCULATE(SUM(Sales[Sales]),PREVIOUSDAY(Sales[Date]))
Create calculated measure for stock differences between days:
stock differences between days = sum(Sales[Sales])- [Prev Sales]
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri Nguyen
