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.

Anonymous's avatar
Anonymous
Not applicable
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.

KG1's avatar
KG1
Resolver I
4 years ago

Brilliant thanks so much Stephen