topic Re: DAX Question Averag in DAX Commands and Tips

DAX Question Averag

jp25 — Mon, 08 Feb 2021 07:13:35 GMT

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,

Re: DAX Question Averag

amitchandak — Mon, 08 Feb 2021 07:23:00 GMT

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")

Re: DAX Question Averag

jp25 — Mon, 08 Feb 2021 14:55:03 GMT

amitchandak Thank you. That helped.

Appreciate your response