AVERAGEX formula not taking the accurate figures

[ANHAMINE]

I want to take Monthly Average of few numbers from a certain date range

Both the figures [ Date ] & [ Qty] are available in single table.

I am trying to use following formula : 

Average Demand = AVERAGEX(VALUES[Table1[Date].[Month]),CALCULATE(SUM(Table1[QTY],DATESBETWEEN[Table1[Date], Start Date , End Date))

Output I am getting is simply 'Summation' of Qty , not the 'Monthly Average' as desired.

If I remove .[Month] , it gives me certain average but it is based on 'Daily Average' - not 'Monthly' - 

Can someone please help in here?

[FreemanZ · Accepted solution]

hi @ANHAMINE 

you need a dedicated month column to average on, like

Month = FORMAT([Date], "YYYYMM")

then rewrite the measure like:

Average Demand = AVERAGEX(VALUES[Table1[Month]),CALCULATE(SUM(Table1[QTY],DATESBETWEEN[Table1[Date], Start Date , End Date))

[ANHAMINE]

It worked ! You are simply magical 😊

Thank you for all your help !