Calculating YTD absolute error and YTD average abs error

Question

Hello all,Hoping for some assistance with this effort. I have the below matrix example, calculating the absolute error of forecast vs sales by product family by month:&nbsp;I'm trying to calculate the YTD abs error and YTD average absolute error - so going from top to bottom (Cube to Sphere) for February I would expect the YTD avg abs error to be 11.02, 31.965, 42.99, and 132.28 respectively, and March would start off with 9.55 for Cube (avg of 11.02 for Jan + 11.02 for Feb + 6.61 for March), and so on.&nbsp;I'd additionally like the YTD abs error value to be the sum of each month's abs error, rather than recalculating it monthly based on the sum of the FC and sales. (So, for example, March's YTD abs error for Cube would be 11.02+11.02+6.61 = 28.65, not the sum of orders from Jan-Mar (22.05+33.07+26.46) - the sum of FC from Jan-Mar (11.02+22.05+33.07) = 15.44).&nbsp;I've attached a GDrive link to the example pbix for examination - please go easy on my limited DAX knowledge at this point.&nbsp;Help&nbsp;

amitchandak · Answer

U382911 , For ytd you can use time intelligence using date table
&nbsp;
YTD Sales = CALCULATE(SUM(Table[error]),DATESYTD('Date'[Date],"12/31"))
&nbsp;
for error
&nbsp;
YTD Sales = CALCULATE(Averagex(Values(Date[Month Year]), calculate( SUM(Table[error]))) ,DATESYTD('Date'[Date],"12/31"))
&nbsp;
&nbsp;
Power BI — Year on Year with or Without Time Intelligence https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38ahttps://www.youtube.com/watch?v=km41KfM_0uA
&nbsp;
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period, Custom Period till date: https://youtu.be/aU2aKbnHuWs&amp;t=145s