Forum Discussion

mohammedismail's avatar
mohammedismail
Helper I
4 years ago

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(Second Chart) . X Axis is the Daily Cumulative Sales amount.

 

TIA

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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"))