Forum Discussion
rbalza
Helper III
Helper IIICalculating Previous Week & 2 Weeks prior using Data using Slicer
Hi Everyone, Need the help of calculating the previous week's total number of hours compared to the current week when using a slicer filter. I am using the weekending slicer which is based on th...
This one works :O)
Total Hours Previous Week = CALCULATE( [Total Hours Worked], DATEADD('Fact Pay Detailed Report'[Timesheet],-7,DAY))
rbalzaHelper III
Helper IIIThis one works :O)
Total Hours Previous Week =
CALCULATE( [Total Hours Worked],
DATEADD('Fact Pay Detailed Report'[Timesheet],-7,DAY))