Forum Discussion

ahmoh43's avatar
ahmoh43
New Member
2 years ago
Solved

weekly running total

I want to make weekly trend as monthly trend 
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ahmoh43 

    Thanks for the solution MFelix  provided, and i want to offer some information for you to refer to.

    Sample data

     

     

    Create a measure.

     

    MEASURE =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        ALLSELECTED ( 'Table' ),
        'Table'[WeekNo] <= MAX ( 'Table'[WeekNo] )
    )
    

     

    Then put the  the measure to the y-axis.

    Output

     

     

    Best Regards!

    Yolo Zhu

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