Forum Discussion
electrobrit
Post Patron
Post Patronhours by day previous week
this seems so easy but my mind can't wrap my head around it. Trying to show how many hours spent doing certain tasks and compare to last week. I have used all kinds of formulas I'm finding and it's...
If you are trying to find the same day last week, then you can create a calculated columns as follow:
Total Last week = VAR day_lastweek = DATEADD(Table11[Date],-7,DAY) RETURN CALCULATE(SUM(Table11[Total Hours]), FILTER(Table11, Table11[Date] =day_lastweek))You will get this result:
If you are trying to find the same day last week, then you can create a calculated columns as follow:
Total Last week = VAR day_lastweek = DATEADD(Table11[Date],-7,DAY) RETURN
CALCULATE(SUM(Table11[Total Hours]),
FILTER(Table11,
Table11[Date] =day_lastweek))You will get this result: