Visualization: stock differences between days

[Jaromir]

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

[tringuyenminh92]

Hi @Jaromir,

What is meaning of differences between days, could you show me 1 example for that logic? so i could understand it correctly.

[Jaromir]

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!

[tringuyenminh92 · Accepted solution]

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

[Jaromir]

Hi @tringuyenminh92,

thanks for your response. I have created a calculated measure as you suggested:

PrevStock = CALCULATE(SUM('data'[stock]); PREVIOUSDAY('data'[date]))

But it only returns empty field. I have checked and there is a row with a previous day date. What could I be doing wrong?

Thanks again.

[Jaromir]

I found the problem, had to use PREVIOUSDAY('data'[date].[Date]).