Forum Discussion
calculate average over period
Hello, I'm sure this has been answered but I cannot find a answer that suits my situation. I'm trying to get an average over a date range but my results aren't correct? month APR may jun...
The date column I'm referencing looks fine, SUM works using this method, it is just AVERAGE that is not returning correct results? I've ran against just 3 figures and it comes back skewed. The only way I've got it working is to do a manual sum
6MonthAverage = CALCULATE (
SUM( SOPInvoiceCreditLine[new quantity] ) / 6,
DATESBETWEEN(SOPInvoiceCreditLine[InvoiceCreditDate],EOMONTH(TODAY(),-6),TODAY())
)