YTD Dates Inconsistent with YTD from Previous Year

Hey Anonymous ,

 

I recommend reading this article, pay attention to the notes: https://dax.guide/sameperiodlastyear/

 

For this reaseon I had to change the DAX statement of the DateTable to this:

DateTable = CALENDAR(
    //MIN(Orders[Date]),MAX(Orders[Date])
    DATE( 2015 , 1 , 1 )
    , DATE( 2020 , 12 , 31 )
    )

Then I created these two measures:

Tom Current Year 2020-01-01 - 09-10 = 
var _lastdate = DATE( 2020 , 9 , 10 )
var _firstDayOfTheYear = DATE( YEAR(_lastdate) , 1 , 1 )
var theDates = DATESBETWEEN( 'DateTable'[Date] , _firstDayOfTheYear , _lastdate )
return

CALCULATE(
    SUM('Orders'[Sales])
    , FILTER(
        ALL('DateTable')
        , 'DateTable'[Date] in theDates
    )
)

And the more interesting one:

Tom Previous Year 2019-01-01 - 09-10 = 
var _lastdate = DATE( 2020 , 9 , 10 )
var _firstDayOfTheYear = DATE( YEAR(_lastdate) , 1 , 1 )
var theDates = 
    SAMEPERIODLASTYEAR(DATESBETWEEN( 'DateTable'[Date] , _firstDayOfTheYear , _lastdate ))
    

var theStartDate = MINX( theDates , 'DateTable'[Date] )
var theEndDate = MAXX( theDates , 'DateTable'[Date])
var noofday = COUNTROWS( theDates )
var thevalue = 
CALCULATE(
    SUM('Orders'[Sales])
    , FILTER(
        ALL('DateTable')
        , 'DateTable'[Date] in theDates
    )
)
return

"startdate: " & theStartDate
& UNICHAR(10) & "enddate: " & theEndDate
& UNICHAR(10) & "no of days: " & noofday 
& UNICHAR(10) & "value: " & thevalue 

It's simply more wordy as I also use this to document what's going on.
Nevertheless, all this allows me to create this:

 

Hopefully, this is what you are looking for.

Regards,

Tom