Forum Discussion

meena16_vibrant's avatar
meena16_vibrant
Frequent Visitor
3 years ago
Solved

Need DAX Help

I used below measure to create average of 3 years of sales AVG Sales = var sales_2019=CALCULATE([salesvalue],'Date'[Month]=201812) var sales_2020=CALCULATE([salesvalue],'Date'[Month]=201912) var ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi   meena16_vibrant 

     

    try like:

     
    AVG Sales =
    var sales_2019=CALCULATE([salesvalue], DATEADD('Date'[Date], -3, YEAR))
    var sales_2020=CALCULATE([salesvalue], DATEADD('Date'[Date], -2, YEAR))
    var sales_2021=CALCULATE([salesvalue], DATEADD('Date'[Date], -1, YEAR))
    var avg_sales= (sales_2019+sales_2020+sales_2021)/3
    return avg_sales

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi   meena16_vibrant 

 

try like:

 
AVG Sales =
var sales_2019=CALCULATE([salesvalue], DATEADD('Date'[Date], -3, YEAR))
var sales_2020=CALCULATE([salesvalue], DATEADD('Date'[Date], -2, YEAR))
var sales_2021=CALCULATE([salesvalue], DATEADD('Date'[Date], -1, YEAR))
var avg_sales= (sales_2019+sales_2020+sales_2021)/3
return avg_sales

 

  • meena16_vibrant's avatar
    meena16_vibrant
    Frequent Visitor
    3 years ago

     It worked.Thanks for your help.