topic Re: How to show last 4 years sales with current ytd using DAX in DAX Commands and Tips

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

Anonymous — Wed, 04 May 2022 17:25:31 GMT

Hi,

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

Thanks,

Francis

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

amitchandak — Thu, 05 May 2022 03:01:59 GMT

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

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

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

Anonymous — Thu, 05 May 2022 05:29:19 GMT

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

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

Anonymous — Tue, 10 May 2022 08:07:25 GMT

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