Forum Discussion
Year to Date Graph
I am trying to build a chart that shows the data of each week as well as the YTD total as it goes through the weeks. Currently my DAX function is: Actuals YTD = TOTALYTD(SUM(Table1[Quantity]...
Hi:
I'll attach a file for you. Please see page 2 "YTD". I hope you can mark as solution if this works for you. Thankshttps://drive.google.com/file/d/1lzi428Xm1DqMPlMOkMjXoYKALkvJxvlv/view?usp=sharing
Sometimes it's tough to compare weekly sales to YTD , especially when the YTD figures dwarf the weekly figures.
Hi:
I'll attach a file for you. Please see page 2 "YTD". I hope you can mark as solution if this works for you. Thankshttps://drive.google.com/file/d/1lzi428Xm1DqMPlMOkMjXoYKALkvJxvlv/view?usp=sharing
Sometimes it's tough to compare weekly sales to YTD , especially when the YTD figures dwarf the weekly figures.
This solution worked for me:
YTD = CALCULATE(sum(Table1[Quantity]),DATESYTD('Date Table'[Date]))
Also, adding YTD on a secondary axis helps solve the problem of YTD dwarfing the actuals.