Sum of the amount of sales the previous 5 months

[Anonymous]

Hi;

I want to calculate the cumulative of sales quantity of the previous 5 months without counting the current also I want it to be dynamic depending on the current month.

Data example bellow

[Ashish_Mathur · Accepted solution]

Hi,

Drag this measure to a card visual

=CALCULATE([Cantidad],DATESBETWEEN(Calendar[Date],EDATE(EOMONTH(TODAY(),-1)+1,-5),EOMONTH(TODAY(),-1)+1))

Hope this helps.

[Anonymous]

It Works, thank you.

[Ashish_Mathur]

You are welcome.

[MFelix]

Hi @Anonymous ,

Try the following measure:

Sum Last 5 Months =
CALCULATE (
    SUM ( 'Table'[Quantity] );
    DATESINPERIOD ( 'Table'[Date]; MAX ( 'Table'[Date] ); -6; MONTH )
)
    - SUM ( 'Table'[Quantity] )

Replace the table name by the your data. If the date column is on a different table just change also that column to the correct one.

Regards,

MFelix

[Anonymous]

It doesn't work because I have a data since 2016.

[MFelix]

The number of dates should no be an issue, since the calculations is made based on your date a going backward.

Did you tried the measure?

Can you share a mockup file?
Regards,
MFelix