Forum Discussion
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])))
- Anonymous8 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
- AnonymousNot 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