I would like to know how i have to adapt my code for a measure that is working for a calculated column.
There are two tables, one date table and one value table. The value table includes 4 columns of interest:
Project name, Workload (h) per day, Start Date, End date
The calculated column in the date table had to following code to sum up the workload on each day:
Workload (h) test = CALCULATE(
SUM('Monitoring Demand Input'[Workload (h) per day]),
'Monitoring Demand Input',
'Monitoring Demand Input'[Start Date] <= 'Date'[Date]
'Monitoring Demand Input'[End Date]>= 'Date'[Date]
However, this code doesn't work with a measure as the column Date doesn't contain a single/unique value:
I need the measure to allow the filtering on the column Project name, which is lost by the calculated column.
Thank you for your help and time!