Forum Discussion
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
- Ashish_MathurSuper User
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)- AnonymousNot 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!
- Ashish_MathurSuper User
You are welcome.