The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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])) )