Comparing current week with previous week production

Hi,

If you aren't comparing data on a multi year level the easiest way to do this is like this:

This week =
var _TW = WEEKNUM(MAX(Table[Date])) return
CALCULATE(Sum(Table[Production]),ALL(Table),WEEKNUM(Table[Date])=_TW)

Last week = 
var _LW = WEEKNUM(MAX(Table[Date]))-1 return
CALCULATE(Sum(Table[Production]),ALL(Table),WEEKNUM(Table[Date])=_TW)


Diff = [This Week]-[Last Week]


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Hi mohammadyousaf ,

I need to make some additions.
The code ValtteriN has some problems in encountering data across years. This is because it is calculated based on the results returned by weeknum. So this problem can be avoided by using the following formula.

Current week =
VAR _cweekday =
    WEEKDAY( SELECTEDVALUE( 'Table'[Date] ), 3 )
VAR _cstart =
    SELECTEDVALUE( 'Table'[Date] ) - _cweekday
VAR _cend = _cstart + 6
RETURN
    CALCULATE(
        SUM( 'Table'[Production] ),
        FILTER( ALLSELECTED( 'Table'[Date] ), [Date] >= _cstart && [Date] <= _cend )
    )

Previous week =
VAR _cweekday =
    WEEKDAY( SELECTEDVALUE( 'Table'[Date] ), 3 )
VAR _cstart =
    SELECTEDVALUE( 'Table'[Date] ) - _cweekday - 7
VAR _cend = _cstart + 6
RETURN
    CALCULATE(
        SUM( 'Table'[Production] ),
        FILTER( ALLSELECTED( 'Table'[Date] ), [Date] >= _cstart && [Date] <= _cend )
    )

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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