sumx for 3 last year december

[pani_victoria]

Hello!

So, please help

I have data with daily sales.
December is the most profitable month of the year and I want to calculate the growth rate to the previous month.

The calculation I want to do is as follows:

I take the sales for December and November for the last 3 years, then divide the sales of December by the sales of November and then average these 3 values

How do I get the result in DAX?

I have a measure Sales_current
I have a measure Sales_previous month

[Gabry]

Hello,

based on the sample data you provided, this is the measure to get the job done

Measure = AVERAGEX('Table',CALCULATE(AVERAGEX('Table', DIVIDE(SUM('Table'[dec]),SUM('Table'[nov]))), 'Table'[year]=YEAR(TODAY())-1 || 'Table'[year]=YEAR(TODAY())-2 ||'Table'[year]=YEAR(TODAY())-3))

Let me know if it works for you 😉

[pani_victoria]

@Gabry 
Thanks for your help, but
I don't know how to apply this formula because I don't have such a table in my data.
The table in the example is the result on the basis of which I wanted to show the calculation algorithm.

[Ashish_Mathur]

Hi,

If your question is still unanswered, then share some data to work with and show the expected result.  Do you want to see the result in a card visual?

[bhanu_gautam · Accepted solution]

@pani_victoria , You can create measures to calculate the sales for December,November for the last 3 years.

DAX
Sales_December_Last3Years =
CALCULATE(
[Sales_current],
FILTER(
ALL('Date'),
'Date'[Month] = 12 &&
'Date'[Year] IN {YEAR(TODAY())-1, YEAR(TODAY())-2, YEAR(TODAY())-3}
)
)

Similarly do for November than

Growth_Rate_Per_Year =
DIVIDE(
[Sales_December_Last3Years],
[Sales_November_Last3Years],
0
)

In the end 

Average_Growth_Rate_Last3Years =
AVERAGEX(
VALUES('Date'[Year]),
[Growth_Rate_Per_Year]
)

[pani_victoria]

@bhanu_gautam 
your solution is perfect!
Thank you!!