Forum Discussion
Year to Date Graph
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.
Whitewater100 Thank you for your suggestion, but neither of these expressions provided a different visual than shown above. Are there any other ways to calculate year to date?
Solution SageYes but those should work if you have date table marked as Date Table with only consequtive date.
If this next sugestion doesn't work, please send an example pbix file as something seems off.
Total Sales = SUM(Table1[Quantity])
Cumulative Sales = CALCULATE([Total Sales],
FILTER(ALLSELECTED('Date Table'[Date]),
'Date Table'[Date] <= MAX('Date Table'[Date]))
If you have multiple years you can add IF statement preceding:
= IF('Date Table'[Year] = "2022", FORMULA ABOVE