Forum Discussion

phanimusunuri9's avatar
phanimusunuri9
Frequent Visitor
8 years ago
Solved

Week over Week Comparison

Hi All,   I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales". To be precise, if today is 'Monday' i want to compare it with last 'Monday', if 'Tuesday then last week ...
Need Help
Tips and Tricks
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    phanimusunuri9

     

    You should have Year, Week Number and Weekday columns in your table. Or you can generate with calculated column. 

     

     

    WeekNumber = WEEKNUM(Table[Date],2)
    WeekDay = WEEKDAY(Table[Date],2)

    Then you can create a measure like: 

     

     

     

    Difference =
SUM ( Table[Sales] )
    - CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALL ( Table ),
            Table[Year] = MAX ( Table[Year] )
                && Table[WeekNumber]
                    = MAX ( Table[WeekNumber] ) - 1
                && Table[WeekDay] = MAX ( Table[WeekDay] )
        )
    )

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

phanimusunuri9

 

You should have Year, Week Number and Weekday columns in your table. Or you can generate with calculated column. 

 

 

WeekNumber = WEEKNUM(Table[Date],2)
WeekDay = WEEKDAY(Table[Date],2)

Then you can create a measure like: 

 

 

 

Difference =
SUM ( Table[Sales] )
    - CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALL ( Table ),
            Table[Year] = MAX ( Table[Year] )
                && Table[WeekNumber]
                    = MAX ( Table[WeekNumber] ) - 1
                && Table[WeekDay] = MAX ( Table[WeekDay] )
        )
    )

Regards,

Utsav_cpgio's avatar
Utsav_cpgio
New Member
3 years ago

I have a large amount of data because of that i cant use this. can you help me how to compare without dax.