Need help with a measure stock cycle

[Luukvv93]

Hello community, I need your help with a measure

I have a dataset including stock replenishment and quantity sold per date.

The distribution looks as follows:

The measures I'm using have the following DAX

Quantity sold = SUM(quantity sold)

Stock replenishment = SUM(stock replenishment)

Now I want a measure that looks like the line below. Each time stock has been replenished the line goes up, and for each day quantity is sold it deducts from the stock until stock is replenished again. 

Here I have some sample data:

Date Stock replenishment Quantity sold
15-3-2019 11088 5123
16-3-2019 4200
17-3-2019 1000
18-3-2019 2016 500
19-3-2019 11088
20-3-2019 3109
21-3-2019 11088 9000
22-3-2019 2800 3600
23-3-2019 4800
24-3-2019 2000
25-3-2019 11088

[v-yuta-msft · Accepted solution]

@Luukvv93 ,

I would suggest you to use Gantt Chart or Waterfall chart.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381364?tab=Overview

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.