Forum Discussion
Solved
undefined
I have data imported from server and need to create columns that will be measuring YTD figures upto particular week of a selected year for example if I select week 2018-39 so the YTD should be calculated from week 1 to week 39 .
Hi bhushan_patil,
You can achieve this easily by using the TOTALYTD function. There should be a date table. Please check out the demo in the attachment.
Measure = TOTALYTD(sum(FactSales[Sales]), 'Calendar'[Date])
Best Regards,
Dale
1 Reply
Hi bhushan_patil,
You can achieve this easily by using the TOTALYTD function. There should be a date table. Please check out the demo in the attachment.
Measure = TOTALYTD(sum(FactSales[Sales]), 'Calendar'[Date])
Best Regards,
Dale