Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |