Forum Discussion

mangopop's avatar
mangopop
Frequent Visitor
9 years ago

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...
mangopop's avatar
mangopop
Frequent Visitor
9 years ago

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())
)