Forum Discussion

QQQ's avatar
QQQ
Icon for Advocate II rankAdvocate II
9 years ago
Solved

TOTALYTD does NOT take cumulative

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_...
Need Help
  • QQQ's avatar
    QQQ
    9 years ago

    Hello nickchobotar TomMartens Interkoubess

     

    Thank you all for the quick and helpful responses.

     

    I just realized my Months in Pivot Table was from wrong table. Instead of getting it from Data table (which I named 'Calendar'), I got it from the Facts table.

     

    Below is the updated table

     

     

     

     

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
9 years ago

Hi QQQ,

 

Please try YTD_Matches = CALCULATE(sum(Complete_Detailed_Incidents[Matches]),DATESYTD('Calendar'[date]))

 

And let us know.

 

Thx.

 

 

 

QQQ's avatar
QQQ
Icon for Advocate II rankAdvocate II
9 years ago

 

Thanks for the quick response!

 

However I found the solution.

 

The Months should be from Date Table (which I named 'Calendar'). Instead, I originally got the dates from the Fact table.