Last week I was challenged by a co-worker: *‘create a way that a tabular cube
case serve a YTD value for different time hierarchies.’ *Because I work at a
retailer at this moment, there is a fiscal calendar and a 454 calendar, which of
course doesn’t align in the begin and end date.
While I was writing this post, Marco Russo wrote a great post on how to
createdifferent xTD values. Please read it:
http://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/ (Note to
myself: do not postpo