Forum Discussion
YTD Average
Dear all,
I'm trying to calculate the YTD Average value - but I would need your help on this KPI & DAX language.
Data are like this:
-> Conformity level (Grade A = OK/NON OK per scan/factory/etc.).
So I would need to calculate the average of grade A/period and then make the average from the beginning of this year until a specified period (ex. P5 - or 31st May).
Hope it's clear - let me know if not.
Best regards
Hervé
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])))
5 Replies
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])))Hi Anonymous ,
The link you share isnt available,could you pls modify it and share again?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
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,
KellyDid I answer your question? Mark my post as a solution!
