Calculating Week over Week Percent Change

[Anonymous]

Hi All,

I am trying to calculate week over week change percentage and display the data in a weekly format. I am usng the below measure code 

Week Over Week = 
VAR todaycost = CALCULATE(
    COUNTROWS(Requests),
    FILTER(Requests,Requests[Request Type] = "Escalation"),
    DATEADD('DateTable'[Date],0,DAY)
    )
   
VAR LastWeek =
    CALCULATE (
        COUNTROWS(Requests),
        FILTER(Requests,Requests[Request Type] = "Escalation"),
        DATEADD('DateTable'[Date],-7, DAY)
    )
RETURN
   DIVIDE(todaycost-LastWeek,LastWeek, 0)
   

This displays the week over week change for the latest data when put on a card. However, when I try and break it out by weeknumber, nothing shows. I have gotten down to the problem line being

"FILTER(Requests,Requests[Request Type] = "Escalation")".  - When this line is removed, it works as expected.

However, in my table I have a column of status's and I only want the week over week change for the "Escalation" status. 

Here is a picture of my date table 

[Ashish_Mathur · Accepted solution]

Hi,

Ensure that to your visual, you drag Week of Year from the Date table.  Also, does this measure work?

Week Over Week = 
VAR todaycost = CALCULATE(
    COUNTROWS(Requests),
    Requests[Request Type] = "Escalation",
    DATEADD('DateTable'[Date],0,DAY)
    )
   
VAR LastWeek =
    CALCULATE (
        COUNTROWS(Requests),
        Requests[Request Type] = "Escalation",
        DATEADD('DateTable'[Date],-7, DAY)
    )
RETURN
   DIVIDE(todaycost-LastWeek,LastWeek, 0)

[Anonymous]

I was using Week of Year from the date table, but what fixed it was removing "Filter" and just using "Requests =". Thankyou very much!

[Ashish_Mathur]

You are welcome.