Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Rolling by Week

Hi   I am trying to create a rolling sum between Monday and Sunday as shown below in column "Rolling earned". How do you calculated this value.      Earned week is calculated as following:...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Excellent, working fine.

     

    Thank you, Mikelytics...;)

mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Anonymous ,

maybe this works for you

Measure = 
VAR MinDate = MIN('Facts8'[Date])
VAR MaxWeek = MAX('Facts8'[Week])
RETURN
SUMX(
     FILTER(
          ALL('Facts8'),
           MaxWeek = 'Facts8'[Week] && MinDate >='Facts8'[Date]
           ),
    'Facts8'[Earned]
)

this is the table that I have used

and this is the result

 

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