Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line Chart to Show Daily Increase

I currently have the following data and I'm trying to create a chart that will show a diagonal increase from the Start Date to the End Date increasing each day by the Points Per Day (for example: for version 1, day 1 would show 4.08, day 2 would show 8.16,  day 3 would show 12.24, etc.)

 

Version       Start Date       End Date       Total Points       Number of Days       Points Per Day

1                 8/2/2018        9/8/2018        151                   37                             4.08

2                 9/9/2018        10/16/2018    160                   37                             4.32

 

I have created a Measure to use as the value for the chart, but it is showing a horizontal line of just the Points Per Day and not a cumulative increase per day when I use a slicer on the Version.  I would appreciate any assistance with the DAX to generate the diagonal daily increase that I'm looking for.

 

Cumulative Points = Sumx(filter('PointsPerDay',max('DateDimension'[DateKey])<='PointsPerDay'[End Date] && MAX(DateDimension[DateKey])>='PointsPerDay'[Start Date]),calculate(sum(PointsPerDay[Points Per Day]),filter('PointsPerDay',max('DateDimension'[DateKey])<='PointsPerDay'[End Date] && max(DateDimension[DateKey])>='PointsPerDay'[Start Date])))

  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    You can firstly create a custom column in Query Editor to list all dates between start date and end date, then calculate the daily increase usin DAX. For more details, please review attached PBIX file.

    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    You can firstly create a custom column in Query Editor to list all dates between start date and end date, then calculate the daily increase usin DAX. For more details, please review attached PBIX file.

    Regards,
    Lydia