How to get sales value upto last month YTD same like previous Year YTD

[ganesanr1002]

Dear Floks, 

I m looking for the YTD Sales upto Last Month Example (Current Month is Jan . I need to show the YTD Sales from April 22 upto Dec 22  (Fiscal Year Start with April )). I did the measure using below formula 

YTD Upto Last Month 

var _start=DATE(year(TODAY()),month(TODAY()),1)
var _calc=CALCULATE('Measure'[Sales],'Dim Date'[Date]<_start)
return if(_calc>0,_calc,0)

same like that i m looking for Last Yr YTD Sales Upto Apr 21 to Dec 21 and i have slicer only for the fiscal year . I'm Getting not the result properly can any body helps. 

[FreemanZ]

Hi @ganesanr1002

try like:

Last Yr YTD = 

var _start= EDATE( DATE(year(TODAY()),month(TODAY()),1), -12)

var _calc=CALCULATE('Measure'[Sales],'Dim Date'[Date]<_start)

return if(_calc>0,_calc,0)

in case of issue, please consider providing sample dataset well reflecting your challenge. 

[Greg_Deckler]

@ganesanr1002 What does your date table look like?

[ganesanr1002]

Hey , Thanks for the response , 
Here is the script i m using for the dim date 
https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-...