topic Re: Cumulative total for last month in DAX Commands and Tips

Cumulative total for last month

Anonymous — Mon, 02 Nov 2020 02:44:59 GMT

Hello,
I want to build a table to compare the cumulative sales of the current month to the sales of last month. The problem is when I calculate de sales from last month my table shows only the values based on the day of the current month. For example, this month I have sales from day 1 to day 17, which is right. But form the last month I what to show the cumulative sales from day 1 to day 30 and not until day 17 as below.

Thanks in advance!!

Re: Cumulative total for last month

amitchandak — Mon, 02 Nov 2020 02:53:58 GMT

Anonymous , Try like

Last MTD QTY forced=
var _max1 = maxx(allselected('Date')'Date'[Date])
var _max = date(year(_max1),month(_max1)-1,day(_max1))
return
CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)

Re: Cumulative total for last month

Anonymous — Mon, 02 Nov 2020 13:57:11 GMT

Hi amitchandak,

Thanks for your help!!