Forum Discussion
Average not returning the expected result
I am facing and issue with Average function where it returns the same values as they are in original rows. First Column represents some numbers and the last column I am trying to do average. ...
ryan_mayu
Super User
Super Useris this what you want?
Column = AVERAGEX(FILTER('Table',year('Table'[date])=year(EARLIER('Table'[date]))),'Table'[value])