Forum Discussion

miguesnet's avatar
miguesnet
Frequent Visitor
2 years ago
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 = Stock start period + Prod - sales

 

Thanks a lot in advance for your help 

 

Mickael

Need Help
  • mickey64's avatar
    mickey64
    2 years ago

    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 -

     

2 Replies

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    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 -

     

    • miguesnet's avatar
      miguesnet
      Frequent Visitor
      2 years ago

      Thanks a lot for your Help Mickey 64

       

      Mickael