Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating a MTD Average based on Date and Entity

Hello, I have a table with a number by person by date. I want to calculate the average for current month/month(s) previous. I've tried 2 calculations, neither work: Average#MTD = Averagex(values(...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - Are these calculated columns or measures? Look like calculated columns. Try:

    Average#MTD= AVERAGEX(Filter(Table,Table[Date].[Date]<=EARLIER(Table[Date].[Date] && [Name]=EARLIER(Table[Name])),Table[Number])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous - Are these calculated columns or measures? Look like calculated columns. Try:

Average#MTD= AVERAGEX(Filter(Table,Table[Date].[Date]<=EARLIER(Table[Date].[Date] && [Name]=EARLIER(Table[Name])),Table[Number])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yepp! That did it - THANK YOU very much for the help!