Forum Discussion
TOTALYTD NOT WORKING
Hello, I am trying to get the accumulated sales. These are my measures:
Total Neto = SUM(Registros[Neto])
- 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.
Hi Anonymous ,
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/
2 Replies
Hi Anonymous ,
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/