Solved: undefined

bhushan_patil · ‎10-09-2018

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 · ‎10-10-2018

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft · ‎10-10-2018

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.