Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating Week over Week Percent Change

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 

 

 

 

  • 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)

3 Replies

  • 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's avatar
      Anonymous
      Not applicable

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