DAX Question Averag

[jp25]

Hello All, 

I am working on the following table. 

in this table, every month has more than 3 sources of income. namely: salary, Interest & Rental Income. 

I am struggling to find a way to calculate the average monthly income till date, and want to continue updating as more data in future gets updated where a month may have a different number of income sources. 

I Really appreciate any help in this regards.

Thanks, 

[amitchandak · Accepted solution]

@jp25 , Your date seems like a month, but in case it, not the month, have a month year and try a measure like

AvergaeX(Values(Table[Month Year]),calculate(Sum(Table[Value])))

new columns

Month Year = FORMAT([Date],"mmm yy")
Month Year sort = FORMAT([Date],"yyyymm")

[jp25]

@amitchandak Thank you.  That helped. 

Appreciate your response