Forum Discussion

Bondeuz's avatar
Bondeuz
Frequent Visitor
3 years ago

Display Average Monthly Sales Quantity

Hi,   Im looking into displaying avarage montly sales depending on the amount of months a product has been sold.   I want to show the SKU, Current inventory and Average monthly sales quantity in ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Bondeuz , try a measure like

 

AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Quantity]))

Bondeuz's avatar
Bondeuz
Frequent Visitor
3 years ago

Could it have something to do with my quantity in transaction list being negative values? If i use a list of absolute values would that work?