Forum Discussion
YTD Average
Anonymous , Try like this with a date table
calculate(averageX(values(Table[period]), calculate(sum(Table[grade A]))), datesytd('Date'[Date]))
If you year period, make sure they are in a separate table join to this table
YTD= CALCULATE(saverageX(values(Table[period]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[period] <= Max('Date'[period]) ))
LYTD = CALCULATE(averageX(values(Table[period]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[period] <= Max('Date'[period])))
Hello v-kelly-msft
Can you try again please and tell me if it works? (or may be my organization blocks it).
Hervé
Hi Anonymous ,
Still unavailable,could you pls paste some sample data for test?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!