Forum Discussion
muelleto
9 years agoRegular Visitor
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...
- 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
9 years agoRegular Visitor
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
- igor9 years agoFrequent Visitor
Ive try this solution and it works, but I dont know how to use in two distinct years.
Can you help me?- Vvelarde9 years agoCommunity Champion
hi, in this case you need a cumulative Total
Check this: http://www.daxpatterns.com/cumulative-total/