get total sum of item before the selected date in slicer

[qhpowerbi]

Hi all,

Assume I have data as below; example if the current slicer is on April, how I can get the total sale previous month except April?

Thank you!

[amitchandak · Accepted solution]

@qhpowerbi , Assume you have date in table that is joined with date of date table , and date from date table is used in slicer

LMTD =
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = date(Year(_max1), month(_max1)-1, day(_max))
var _min = eomonth(_max1,-2)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

Last Month =
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = eomonth(_max1,-1)
var _min = eomonth(_max1,-2)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))