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

     

     

     

     

QQQ's avatar
QQQ
Icon for Advocate II rankAdvocate II
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

 

 

 

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi QQQ,

     

    Glad to hear that you have resolved the problem. Would you please kindly mark the helpful response and your resolution as an answer so that others having similar concern can find the solution more easily?

     

    Regards,
    Yuliana Gu