- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sum of contract hours of a week with different Daily Hours
Hi
I have an issue where I am trying to get the sum of a some what dynamic weekly value of contract hours for a clinet which has a contract structure as follows:
I also have some budgets which are only Mon-Fri or Sat-Sun.
I have managed to plot this into a line graph as well:
My issue is now when I try to sum the budget of the week multiplying the value of the contrtacted hours (Example):
Into a measure I get the following value:
Using the DAX:
Working Days Working Period * <-->* Pro Rate Budget Working Days
The working days table is as follows:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Housden996 , Try to use the date from the Working day in a measure like
Sumx(values(WorkingDay[date]), calculate(SUM('Pro Rate Budget'[Daily Hours]) * COUNT('Period File'[Date])) )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Housden996 , Try to use the date from the Working day in a measure like
Sumx(values(WorkingDay[date]), calculate(SUM('Pro Rate Budget'[Daily Hours]) * COUNT('Period File'[Date])) )

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-09-2024 04:39 AM | |||
08-02-2024 08:45 AM | |||
10-07-2024 03:08 AM | |||
10-01-2018 12:16 PM | |||
07-22-2024 09:23 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |