undefined

[bhushan_patil]

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 .

[v-jiascu-msft · Accepted solution]

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