Forum Discussion
mohammedismail
4 years agoHelper I
Daily Cumulative Total - Line Chart
Hi, I have a Sales Fact table and a Calendar table.. Is it possible to create a Line chart which starts from ZERO to show the sales growth year on year something similar to the picture below(Seco...
amitchandak
4 years agoSuper User
mohammedismail , Create a measure with datesytd measures and show with year, I doubt that will start with 0. but start from 1st day or month amount
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))