Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Solved! Go to Solution.
@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])) )
@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 |
---|---|
84 | |
77 | |
72 | |
71 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |