Sum up daily pageviews by week

[Anonymous]

Hello,

I'm trying to figure out how to create a calculated column (or perhaps a measure?) that takes the sum of daily page views by week.

I.E. It sums up all the pageviews for rows that have a specific unique value in the "week of year" column. 

Please see the included table for reference. Thanks in advance for your help! 

[v-piga-msft · Accepted solution]

Hi @Anonymous,

You could try the formulas below.

1. Calculated column:

Column =
CALCULATE (
    SUM ( 'Table1'[Pageviews] ),
    FILTER ( 'Table1', 'Table1'[Week of Year] = EARLIER ( 'Table1'[Week of Year] ) )
)

2. Measure

Measure =
CALCULATE (
    SUM ( 'Table1'[Pageviews] ),
    FILTER (
        ALL ( 'Table1' ),
        'Table1'[Week of Year] = MAX ( 'Table1'[Week of Year] )
    )
)

Here is the output:

Best  Regards,

Cherry

[Anonymous]

That measure worked perfectly, thank you!