TOTALYTD NOT WORKING

[dennisroman]

Hello, I am trying to get the accumulated sales. These are my measures:

Total Neto = SUM(Registros[Neto])

Acumulado x Año = TOTALYTD([Total Neto],Registros[Fecha factura])

• I have my Calendar table related to my Records table
• My calendar table is marked as date table

My file https://1drv.ms/u/s!AoKF9E1Sd9IuoBsD4vrucUVvPTgb?e=HsqDLb 

This is the result I want to get. In my record table there is only 2019-2020.

Thanks in advance.

[dennisroman]

Thanks a lot. the solution helped me a lot

[tackytechtom · Accepted solution]

Hi @dennisroman ,

Here a potential solution: 

Here the measure:

TomsYTDMeasure = 
TOTALYTD([Total Neto], 'Calendario'[Date])

Please note, the measure will not work for only choosing "Mes" without selecting a specific year. The YTD function cannot to be used accross years.

Does this help? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/