Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
The working days table is as follows:
@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])) )
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |