weekly running total

[ahmoh43]

I want to make weekly trend as monthly trend 

[v-xinruzhu-msft · Accepted solution]

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.

[MFelix]

Hi @ahmoh43,

For this you need to create a cummulative measure that will allow to have the calculation for each week.

You can do a measure similar to this one:

Weekly Cumulative = CALCULATE (SUM(Table[Column]), Table[Week] >= MAX(Table[Week]))

Be aware that I'm assuming that you are only selecting a specific year for the visualization of the chart.