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 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 the fact table.
Here's my measure.
Total Hours Previous Week =
CALCULATE( [Total Hours Worked],
DATESINPERIOD( 'Fact Pay Detailed Report'[Timesheet], MAX( 'Fact Pay Detailed Report'[Timesheet] ), -7, DAY ))
Total Hours Worked = SUM( 'Fact Pay Detailed Report'[Total Hours] )
Solved! Go to Solution.
This one works :O)
Total Hours Previous Week =
CALCULATE( [Total Hours Worked],
DATEADD('Fact Pay Detailed Report'[Timesheet],-7,DAY))
This one works :O)
Total Hours Previous Week =
CALCULATE( [Total Hours Worked],
DATEADD('Fact Pay Detailed Report'[Timesheet],-7,DAY))
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |