The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 .
Solved! Go to 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
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