Forum Discussion
Solved
Week over Week HELP!
I am doing a report on something I thought would be so simple but it's not working. I have to show Cases opened in the week, compared to last week (there are filters they will have by team or indiv...
Hi electrobrit
You may add a week of year column first in Query Editor. Then you may refer to below measure to get the table as requested.
LastWeekTotal = CALCULATE ( COUNT ( VW_Cases[CaseCreatedOn] ), FILTER ( ALL ( VW_Cases ), VW_Cases[Week of Year] = MAX ( VW_Cases[Week of Year] ) - 1 ) )WeekOverWeek = VAR thisweek = CALCULATE ( COUNT ( VW_Cases[CaseCreatedOn] ), FILTER ( ALL ( VW_Cases ), VW_Cases[Week of Year] = MAX ( VW_Cases[Week of Year] ) ) ) VAR lastweek = CALCULATE ( COUNT ( VW_Cases[CaseCreatedOn] ), FILTER ( ALL ( VW_Cases ), VW_Cases[Week of Year] = MAX ( VW_Cases[Week of Year] ) - 1 ) ) RETURN DIVIDE ( thisweek - lastweek, lastweek )Regards,
Cherie
Hi electrobrit
You may add a week of year column first in Query Editor. Then you may refer to below measure to get the table as requested.
LastWeekTotal =
CALCULATE (
COUNT ( VW_Cases[CaseCreatedOn] ),
FILTER (
ALL ( VW_Cases ),
VW_Cases[Week of Year]
= MAX ( VW_Cases[Week of Year] ) - 1
)
)WeekOverWeek =
VAR thisweek =
CALCULATE (
COUNT ( VW_Cases[CaseCreatedOn] ),
FILTER (
ALL ( VW_Cases ),
VW_Cases[Week of Year] = MAX ( VW_Cases[Week of Year] )
)
)
VAR lastweek =
CALCULATE (
COUNT ( VW_Cases[CaseCreatedOn] ),
FILTER (
ALL ( VW_Cases ),
VW_Cases[Week of Year]
= MAX ( VW_Cases[Week of Year] ) - 1
)
)
RETURN
DIVIDE ( thisweek - lastweek, lastweek )
Regards,
Cherie
i like this for WTD but is there a way to see it by day as well? I would like to do a line chart showing daily this week compared to last week same day
