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

     

     

     

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

I'm wondering if the column comes from your fact table and not from Calendar table, if this is the case get your date column from your Calendar table.

 

Your formel is fine, here is an example you may want to look at, have a look at the report page "YTD Startert" the measure "Amount TotylYtd"

Amount TotalYtd = 
TOTALYTD(SUM('FactWithDates'[Amount]),'Calendar'[Date])

looks pretty much the same than your measure.

 

Cheers