Forum Discussion
Solved
Stock Evolution by hours
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 = ...
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