how can I store a specific value from a data base that changes with time?

[Anonymous]

I've created a viz that shows me the surplus stock of items, giving me the monetary value of this surplus. Is there a way to keep save the "today value" to make comparisons with future ones? Exemple: Today we have $2,1 millions of surplus stock. Tomorrow, 2,6, and so on. I need that to see if the team is making progress with the treatment of stock accuracy

[parry2k]

@Anonymous you don't need to save the sum, you can always compare today's sum with the previous date sum or any other previous time. 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@Anonymous well you can always see the trendline by calculating the surplus stock for each date which can be easily done using a DAX measure.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi @parry2k, thanks for replying!

I don't think I understood what you explained to me or I don't think I've made myself very clear... My data is from Hana, so the sum of the surplus stock will change every time as will the part numbers. I want to store this sum (picture below), so I can follow the changes as the time goes by.