Forum Discussion

Advocate I

8 years ago

Solved

Week over Week

Hi, So I have different query names I have a count of each query that are being used every week by my users. I'm trying to compare the count from one week to the previous week for the same query...

Need Help

Tutorial Requests

v-xjiin-msft
8 years ago
Hi TerrificPoet,

Sorry for delay.

Thanks for sharing the sample report. And try this expression:

Count Previous Week = CALCULATE ( [Measure Count], FILTER ( ALLSELECTED ( 'Enterprise_Search' ), 'Enterprise_Search'[Week #] = MAX ( 'Enterprise_Search'[Week #] ) - 1 && Enterprise_Search[Query] = MAX ( Enterprise_Search[Query] ) ) )
Also I have modified the expression in your report. Please make a reference:

https://1drv.ms/u/s!AlqSnZZUVHmshWEOzdZEHmTDtULS

Thanks,
Xi Jin.

v-xjiin-msft

Solution Sage

8 years ago

Hi TerrificPoet,

Sorry for delay.

Thanks for sharing the sample report. And try this expression:

Count Previous Week =
CALCULATE (
    [Measure Count],
    FILTER (
        ALLSELECTED ( 'Enterprise_Search' ),
        'Enterprise_Search'[Week #]
            = MAX ( 'Enterprise_Search'[Week #] ) - 1
            && Enterprise_Search[Query] = MAX ( Enterprise_Search[Query] )
    )
)

Also I have modified the expression in your report. Please make a reference:

https://1drv.ms/u/s!AlqSnZZUVHmshWEOzdZEHmTDtULS

Thanks,
Xi Jin.