Forum Discussion
Janx
10 years agoRegular Visitor
Contiguous date selection error - YTD LY
Hello all, I have a problem with the YTD function. In a nutshell I have a table with Brand, Category, Franchise, Value, KPI etc. I have created a YTD function YTD = TOTALYTD(SUM('Per Day'[Va...
- 10 years ago
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/
KGrice
10 years agoMemorable Member
Have you already checked this solution on PowerPivotPro? This error can happen because of the nature of totals rows. Not sure why you didn't see it before on your previous measures, but it's one more solution to try.