Forum Discussion
Contiguous date selection error - YTD LY
In this case you will need to specify what you consider to be the calendar periods for a year. DAX is defaulting to Jan through Dec. Check out this blog for YTD custom dates.
http://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/
Thanks a lot for your reply.
I also got to the point that I don't get the error anymore, HOWEVER - and this is also the case in your data - the YTD LY formula is not working correctly. For example, in your data set your 2016 data goes through June 2016. However, your YTD LY formula gives you the Revenues for whole 2015 instead of January - June 2015 only, which is the general idea of YTD comparison.
I have the very same problem in my data. I've uploaded my .PBIX file here. I've also included the calculation without using the date table ("YTD ERROR") for reference. As you see, the YTD and YTD LY does not lead to an error, however, it's not calculating last year's YTD correctly. I think there is some error in the date linking... Any ideas?
Thanks!
In this case you will need to specify what you consider to be the calendar periods for a year. DAX is defaulting to Jan through Dec. Check out this blog for YTD custom dates.
http://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/