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,

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Guys,

I am trying to calculate the week by week comparison of the total Number of Jobs from Previous week to current week & % change.

 

 I have Year, Week num, Num of jobs from the Data set, what measure do i use here?

 

i tried to use the above measure, but did not work for me as it is $ Sales & on my report i do not require $sales.

 

thanks for your help here.