TOTALYTD powerpivot > not calculating

[didierwindey]

Hi,

I need the YTD totals for a reporting project with PowerPivot (not PowerBI).  Whatever I try, the values are not adding, an I just get the original value... 

TOTALYTD(SUM([AantalVanNaar-magazijneenheid); tblDatums(Datum)) and some variations

I have a dates table, linked to the other tables. Is there some issue here ?

thanks in advance

Didier

[v-jiascu-msft · Accepted solution]

Hi Didier,

As we can see from your picture, you can't create a proper relationship with the columns that you already have. The relationship should base on the dates rather than the first day of the month. You can check it out in this file.

I think you need to make some changes of the formula to make it work as a calculated column. (I tested with TOTALMTD)

 =
CALCULATE (
    TOTALMTD ( SUM ( [Value] ), 'RightTable'[Date] ),
    ALLEXCEPT ( 'RightTable', 'RightTable'[date] )
)

BTW, please go to here for professional help if you have questions about Excel. If this helps, please mark it as answer.

Best Regards,

Dale