Forum Discussion

muelleto's avatar
muelleto
Regular Visitor
9 years ago
Solved

Accumulate Monthly Values

Hi,   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...
  • muelleto's avatar
    muelleto
    9 years ago

    Ok fixed the problem.

    I forgot to add .[Date]

     

    So the solution looks like this:

     

     

    EffortYTD = TOTALYTD(SUM(Table[Effort)]); Table[Closed Date].[Date])

     

    Br, Tom

muelleto's avatar
muelleto
Regular Visitor
9 years ago

Vvelarde Thank you for your input.

 

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?

 

Br, Tom