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/
kcantor
10 years agoCommunity Champion
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/