Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello - I have a table that has a start date and end date and total hours per role per project.
I have a measure that calculates the number of working days between the start and end date
MSSWorkingDays =
CALCULATE (
SUM ( TDate[Tworkday] ),
FILTER (
TDate,
TDate[Date] >= MIN('MSS Flat Fee Hours'[Start Date])
&& TDate[Date] <= MAX ( 'MSS Flat Fee Hours'[End Date])
)
)
I have another measure that gives me the average hours per day based on number of days / total hours.
MSSPlanHoursPerDay =
DIVIDE(SUM('MSS Flat Fee Hours'[Total Hours]),[MSSWorkingDays])
Works in a table, but what I want to do is show the average number of hours as my values using my calendar table year> Month>week> day … as the columns summing up per date level - I can’t get the values to roll up right with my calendar table. It looks like both the MSSPlanHoursPerDay and Plan hours are behaving the same, but descreasing as I roll up, and increasing as I roll down. Also I can’t seem to get the values with the calendar column to align with the start and end dates of the project. Please let me know what add’l info needed. Thank you much in advance!
These values are correct
But using my calendar dates in a matrix doesn’t add up right start and end months don’t line up with start and end dates and values are not summing correctly and decreasing instead of increasing
Month
Week
Date
How do I sync them up? Thanks in advance
That is a hard problem.
Can you upload your file?
I can try.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |