Forum Discussion

KG1's avatar
KG1
Resolver I
4 years ago
Solved

Rolling Sum Calculation

Hi I need to replicate the WIP weeks formula in Powerbi   Can anyone please advise how I would go about this?   Thank you in advance
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi KG1 ,

     

    Please check this measure

    Measure =
VAR _3months =
    DATESINPERIOD ( 'Table'[Year Month], MAX ( 'Table'[Year Month] ), -3, MONTH )
VAR _sum1 =
    CALCULATE ( SUM ( 'Table'[Value] ), _3months )
VAR _sum2 =
    CALCULATE ( SUM ( 'Table'[Turnover] ), _3months )
RETURN
    _sum1 * SUM ( 'Table'[WIP] ) / _sum2

     

     

    Best Regards,

    Stephen Tao

     

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