Pending Qty Dyanmic

[Skesharwani]

hi team

I have pending data. I want see all pending data except current month

Data

Oct-22

Nov-22

Dec-22

Jan-23

for ex. If current month is Jan-23 So I want Dec, Oct & nov Pending Data

 if i select Dec Then I want Nov & Oct Pending data

[amitchandak]

@Skesharwani , You can have a measure like, Assume [Pending Qty]  is a measure

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