Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I want to create a graph with stock evolution by time frame.
I have the following datas :
I want to project stock in Power BI like this with stock evolution formula
Stock = Stock start period + Prod - sales
Thanks a lot in advance for your help
Mickael
Solved! Go to Solution.
Step 0: I use your data below.
Step 1: I add a 'Qty2' column and change data type of 'Qty2' column on Power Query Editor.
Step 2: I make a 'M_Sum' measure.
M_Sum = CALCULATE(SUM(DATA[Qty2]),FILTER(ALLSELECTED('DATA'[Time Frame]),'DATA'[Time Frame]<=MAX('DATA'[Time Frame])))
Step 3: I make a slicer and a graph.
- Slicer -
- Graph -
Step 0: I use your data below.
Step 1: I add a 'Qty2' column and change data type of 'Qty2' column on Power Query Editor.
Step 2: I make a 'M_Sum' measure.
M_Sum = CALCULATE(SUM(DATA[Qty2]),FILTER(ALLSELECTED('DATA'[Time Frame]),'DATA'[Time Frame]<=MAX('DATA'[Time Frame])))
Step 3: I make a slicer and a graph.
- Slicer -
- Graph -
Thanks a lot for your Help Mickey 64
Mickael
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |