Forum Discussion
Calculate YTD based on multiple columns and dynamic month
I would like to calculate running year to date total based on dynamic fiscal period and columns as per attached file https://1drv.ms/x/s!AtC4vPlx9PrghywunoTDZiy1b0dy
Hi Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Try the demo in the attachment. I hope you didn't share any sensitive data here.
1. Create a date table;
2. Establish a relationship;
3. Create a measure.
Measure = TOTALYTD ( SUM ( Table1[Amount] ), 'Calendar'[Date] )
Best Regards,
Dale
Hey experts, many thank you.... ur sharing solved my 4 days work.