Forum Discussion
Problem when presenting sameperiodlastyear data based on weeknumbers
The inbuilt time intelligence functions must use the date column. If you want to use anything else (like a week number) you must use custom time intelligence. I explain that here http://exceleratorbi.com.au/dax-time-intelligence-beginners/
Is there any reason why you can't use totalytd() to calculate your YTD number? That is the first thing I would try
Thanks for your reply MattAllington
It is a good point, I will change it. But it does not solve my problem:(
The inbuilt time intelligence functions must use the date column. If you want to use anything else (like a week number) you must use custom time intelligence. I explain that here http://exceleratorbi.com.au/dax-time-intelligence-beginners/
Great. I think this should be the solution.
After reading your blog I do understand the Time Intelligence better and I have figured out a solution (using dateadd).
Thanks.