after hours of research and workarounds I'm still struggeling with a huge problem.
I have a list of demands with the column "close date", the column "service" and the column "efforts". Now I'd like to have a stacked column chart with a y-axis displaying the effort and x-axis dsplaying the months from January to the actual month and the stacks should represent the service.
In addition the values from the previous month should be added to the next month.
In the end it should look like this with increasing values but I'm not able to addup the effort from the previous month.
Now I get the error: Calculation error in measure 'Report'[EffortYTD]: A date column containing duplicate dates was specified in call to function 'DATESYTD'. This is not supported.
I know what that means but no idea how to fix this...
Anyhow I think, this is not going to solve my problem because I use the 'closed date' in the Axis field to split the Sum('effort) values into the different month. So it will always just show me the values for each month and it will not add them up. Correct?