Total value of last month selected

[Anonymous]

Hello, can you help me.

I have a table where I have as sales for data. I want to create a measure that tells me only the total sales for the last month that is selected in the selector.
I tried datedd but it didn't work.

For example if the filter is up to November 28th the measure will bring the value of sales from November 1st to November 28th.
If the filter is up to January 12th that only brings the value of sales from January 1st to January 12th

table exemple

visual exemple

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE([Total sales],DATESMTD('Calendar'[Date]))

There should be a Calendar Table with a relationship between the Date column of your base data table to the Date column of the Calendar Table.  The date/month slicer should be built from the Calendar Table.

Hope this helps.

[Anonymous]

Thank you so much, it worked perfectly. The problem that my slicer was not using the calendar here when using datasadd or result was blank. Now everything is ok .. Thanks!

[Ashish_Mathur]

You are welcome.