Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.)...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Dear Amitchandak,

    I have updloaded the excel sheet -> can you help me having the YTD pbix visual? -> I'm struggling with the formulas.

    Hervé