How to show last 4 years sales with current ytd using DAX

[Anonymous]

Hi,

Need help on DAX , client requested to show last 4 years sales with current YTD.

Thanks,

Francis

[Anonymous]

Hi @Anonymous ,

Please mark the answer as solution if it works.

If not, please show some sample data and expected result to us.

Best Regards,

Jay

[amitchandak]

@Anonymous , I think you need the last 4 years + data till today

Try like

Last 4 year till date =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max) -48 )+1
return
CALCULATE([net] ,filter('Date', 'Date'[Date]>= _min &&  'Date'[Date]<= _max))

or

Last 4 year till date  =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max) -48 )+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

[Anonymous · Accepted solution]

Thanks, @amitchandak . Will try this one and let you know shortly.