Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Sales between 2016-2020 DAX Measure

Hi Experts

 

I am trying to work out the avergae sales between two years i.e. 2016-2020 my measure is 

2016-2020 Average = Calculate(average(Sales[Sales Amt]), DATESYTD(ENDOFYEAR(DATEADD(Dim[Date],-4,YEAR)),"12/31"))

 

not sure the abpve is correct

Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    In my test, your dax measure is correct.

     

    My test table:

     

    Dim table:

     

    Measure:

    2016-2020 Average = Calculate(average(Sales[Sales Amt]), DATESYTD(ENDOFYEAR(DATEADD(Dim[Date],-4,YEAR)),"12/31"))

     

    Result:

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies