Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to write a measure that uses other measures to create a projection line for a line chart. I want to add a green dotted line that starts with the Previous_Sprint and adds the Use Vel for the remaining sprints.
The first four columns below make up the chart above. It is the Projected column below that I manually created within Excel to show what I am looking for. (Previous_Sprint is a measure. Use Vel is a column in Use_Vel table.)
Sprint | Orig EffortRT | Curr EffortRT | Effort-DoneRT | Previous_Sprint | Use Vel | Projected |
PI2-1 | 406 | 407 | 407 | PI2-2 | 409 | |
PI2-2 | 766 | 785 | 785 | PI2-2 | 409 | 785 |
PI2-3 | 1097 | 1258 | 952 | PI2-2 | 409 | 1194 |
PI2-4 | 1500 | 1769 | 952 | PI2-2 | 409 | 1603 |
PI2-5 | 1928 | 2163 | 952 | PI2-2 | 409 | 2012 |
PI2-6 | 2340 | 2571 | 952 | PI2-2 | 409 | 2421 |
PI2-7 | 2761 | 2961 | 952 | PI2-2 | 409 | 2830 |
Also, I would like to know if there is a way to not display the redundant data for the Effort-DoneRT field. (This is a running total and since we have not started PI2-4 and beyond, all values are the same.)
Solved! Go to Solution.
I was able to figure out a way to do both by myself. May not be efficient, but it works.
1) First I had to create a numeric field instead of using text field. (Sprint#, Current_Sprint#)
2) Create a measure to capture points Done up to previous sprint.
I was able to figure out a way to do both by myself. May not be efficient, but it works.
1) First I had to create a numeric field instead of using text field. (Sprint#, Current_Sprint#)
2) Create a measure to capture points Done up to previous sprint.
"It is the Projected column below that I manually created within Excel to show what I am looking for. "
What's the formula?
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |