Calculate average sales for calendar month

[Deepankar989P]

Here we have found a simple way to find out the average sales for the calender month. 

Calender Qunatity Sum =

Var startMonth = Date(Year(Today()),1,1)

Var EndMonth =  EOMONTH ( TODAY (),-1)

Return

Calculate(SUMX(Table Name,Qunatiy Column),

Filter(All(Table Name),

'Date Table >= startMonth &&

'Date Table<= EndMonth

)

)

Calender Quantity Average =

Var Month = MONTH(TODAY()) - 1

return

divide(Calender Qunatity Sum,Month,0)

[amitchandak]

@Deepankar989P , Make sure you have month year columns

Calculate(SUMX(Values('Date Table'[month Year]),calculate(Sum('Date Table'[Qunatiy Column]))),
Filter(All('Date Table'),
'Date Table' >= startMonth &&
'Date Table'<= EndMonth
)
)