Forum Discussion
Solved
DAX Question Averag
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...
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")
amitchandak
Super User
Super Userjp25 , 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")
amitchandak Thank you. That helped.
Appreciate your response