Forum Discussion
ahmoh43
2 years agoNew Member
weekly running total
I want to make weekly trend as monthly trend
- Anonymous2 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.
Anonymous
2 years agoNot applicable
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.