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(
...
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)
I was using Week of Year from the date table, but what fixed it was removing "Filter" and just using "Requests =". Thankyou very much!
You are welcome.