Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Cumulative total for last month

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.

fguarnieri00_0-1604284747772.png

Thanks in advance!!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak,

Thanks for your help!!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.