Forum Discussion

jp25's avatar
jp25
Frequent Visitor
5 years ago
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 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's avatar
    amitchandak
    5 years ago

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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