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

Hi,

 

Thank you for the suggestion. I tried the following measure.

Average Monthly Demand = AVERAGEX(VALUES((Calender[Date])),CALCULATE(SUM(Yellow_ItemLedgerEntryBI[Quantity])))

But it just displays the current stock level instead of the monthly average.

I used my Calender date table which is not the in the same table as the posting date of the actual transaction. Is this correct? For my Date table i used CALENDERAUTO(12), could this be a factor?