topic Re: total sales for last 3 months in DAX Commands and Tips

total sales for last 3 months

Sofinobi — Mon, 12 Dec 2022 12:23:46 GMT

hi all,

i'm trying to calculate the total sales for (running) last 3 months (i have already calculated the total sales for all periode "total sales")

ex; we are o december, i need the sales for november, october and septembre.

thank you for your help

Re: total sales for last 3 months

Barthel — Mon, 12 Dec 2022 12:57:39 GMT

Hey Sofinobi,
Use this formula, assuming you have a date table ('d_date') with a date column ('[date]'):

total sales last 3 months = CALCULATE ( [total sales], DATESINPERIOD ( d_date[date], EOMONTH ( MAX ( d_date[date] ), - 1 ), -3, MONTH ) )

Re: total sales for last 3 months

FreemanZ — Mon, 12 Dec 2022 12:59:40 GMT

that depends very much on how you are going to present it or the filter context (what columns you have in your visual, date column? month column?)

Re: total sales for last 3 months

Sofinobi — Mon, 12 Dec 2022 13:13:39 GMT

thank you for you answers,
FreemanZ i want to add a visualisation of the 3 last months (in a matrix or line chart) without filtering dates everytime when month change.

Barthel thank you for your help,
your measure calculate the sum of the 3 months, when i put it in a matrix it doesn't show me the 3 months separately.

Re: total sales for last 3 months

FreemanZ — Mon, 12 Dec 2022 13:18:46 GMT

Barthel's solution shall work, if you plot with d_date[date]. Or what error do you get?

Re: total sales for last 3 months

Barthel — Mon, 12 Dec 2022 13:29:50 GMT

Sofinobi

Yes, this measure shows the value of the three months aggregated. If you want to show the value spread over the three months you will have to work with a disconnected date table. This is a good video explaining how to create something like this.

https://www.youtube.com/watch?v=d8Rm7dwM6gc

Re: total sales for last 3 months

Sofinobi — Mon, 12 Dec 2022 13:35:40 GMT

i dont get an error with that measure, but i get the sum of the 3 months

Re: total sales for last 3 months

FreemanZ — Mon, 12 Dec 2022 13:42:16 GMT

can you make some screenshot?

Re: total sales for last 3 months

Sofinobi — Mon, 12 Dec 2022 14:27:57 GMT

Re: total sales for last 3 months

Barthel — Tue, 13 Dec 2022 17:32:31 GMT

Sofinobi

This might work: put the months in the visual and put KEEPFILTERS in the formula.

total sales last 3 months = CALCULATE ( [total sales], KEEPFILTERS ( DATESINPERIOD ( d_date[date], EOMONTH ( MAX ( d_date[date] ), - 1 ), -3, MONTH ) ) )