Forum Discussion
Calculating YTD absolute error and YTD average abs error
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: I'm trying to calcu...
Thank you. For the monthly buckets, this works perfectly. However, it doesn't appear to be totaling correctly.
Is there an easy change to the formula or another measure to correct this?
Link to updated pbix file: https://drive.google.com/file/d/10mzPDK4dzcV3nx3CIJXt90EFSTRkR73q/view?usp=drive_link