Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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])))
Solved! Go to Solution.
@mrouton,
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
@mrouton,
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |