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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to get previous month sales using dax

I have multiple years and months data in this how to get recent previous month total sales .How system identify previous month on multiple years .

My requirment is once open dashboard I want Previous month total sales in card visualization . I will not select perticular date , automatically sytem will undersatand what is current month and current year based on it will give current previous month total sales .

1 ACCEPTED SOLUTION
CheenuSing
Community Champion
Community Champion

Hi @Anonymous 

 

Please check

https://community.powerbi.com/t5/Desktop/Calculating-a-value-based-on-current-and-previous-month/m-p/707517#M341594

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Reddy5833
Helper I
Helper I

Previous Month Sales =
Var
MonthNumber = IF( MONTH(TODAY())-1 = 0, 12,MONTH(TODAY())-1 )
Var
YearNumber = IF(MonthNumber = 12, YEAR(TODAY()) -1, YEAR(TODAY()))

Return

IF(
ISBLANK(CALCULATE(Sum(Table[sales]), FILTER (ALL('Date'), 'Date'[cal_year] = YearNumber && 'Date'[cal_month] = MonthNumber)))
,0
,CALCULATE(Sum(Table[sales]), FILTER (ALL('Date'),'Date'[cal_year] = YearNumber && 'Date'[cal_month] = MonthNumber))
)
CheenuSing
Community Champion
Community Champion

Hi @Anonymous 

 

Please check

https://community.powerbi.com/t5/Desktop/Calculating-a-value-based-on-current-and-previous-month/m-p/707517#M341594

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Anonymous
Not applicable

Thanks it's useful based on that implemented getting correct result . 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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