Backward calculation from negative and positive values

[joshua1990]

Hello everybody!

I'm looking for a Dax Measure, which shows me from stock of a product up-to-date, the past stocks.

Target is a kind of Bart chart, as shown here:

https://preview.redd.it/len7isujuz141.png?width=710&format=png&auto=webp&s=304e222c3e9f349a5799b548b...

I have the following data available:

• Actual Stock Level

• Negative and positive values per day

The tables are structured as follows:

tblStock

ID Value Date

A1_2

5000

01.12.2019

tblBookings

ID Value Date

A1_2	-5000	01.11.2019
A1_2	5000	01.11.2019

For the past week, the measure must therefore take the sum from the current stock - the negative entries - the positive entries for last week.

How is this to be implemented? Does somebody has any idea? Or a helpful article / blog? Do you need further information?

PS: I already asked at reddit for a sulution with no response at the moment: https://preview.redd.it/len7isujuz141.png?width=710&format=png&auto=webp&s=304e222c3e9f349a5799b548b...

Best Regards

Joshua