MS Excel 2016 Power Pivot TOTALYTD does NOT take cumulative

0
votes

Software: MS Excel 2016 Power Pivot

TOTALYTD acts as sum for each time period rather than a cumulative.

I have a separate Calendar table in Power Pivot and I created relationship with my main table.

Here is the formula

YTD_Matches:=TOTALYTD(sum(Complete_Detailed_Incidents[Matches]),'Calendar'[Date])

When I create Pivot, below is what it looks like. How to fix this?

enter image description here

1
excelpowerpivotdax
What does your data look like? A "Matches" and a "Dates" column? – n8.

1 Answers

1
votes

If you have more than one year in your model, you will need to put year on rows also.

Otherwise the issue is something in your model (something you have not shown).

I was able to create a cumulative year to date using your numbers in an Excel 2016 workbook which you can download from this link.