How to get previous month sales using dax

[Anonymous]

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 .

[Reddy5833]

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

)

[Anonymous · Accepted solution]

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

[Anonymous]

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