Forum Discussion

Jaromir's avatar
Jaromir
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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's avatar
Jaromir
Frequent Visitor
9 years ago

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's avatar
tringuyenminh92
Memorable Member
9 years ago

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's avatar
    Jaromir
    Frequent Visitor
    9 years ago

    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's avatar
      Jaromir
      Frequent Visitor
      9 years ago

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