Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |