Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a two tables
Story Table
Story ID | Story Point |
101 | 5 |
102 | 8 |
103 | 2 |
104 | 13 |
Another one is a mapping of Story & Sprint Table, where one story may belong to more than one sprint
Story Sprints
Story ID | Sprint ID |
101 | 1 |
101 | 2 |
102 | 1 |
102 | 2 |
102 | 3 |
103 | 1 |
103 | 2 |
Now, I want to add a column in this Story Sprint Mapping table called "Story points", that should be derived from "Story points" value of Stories table, and divide by number of sprints it has against the respective story ID in "Story Sprints" table
For e.g. it should show something like this below ->
Story Sprints
Story ID | Sprint ID | Story Points |
101 | 1 | 2.5 |
101 | 2 | 2.5 |
102 | 1 | 2.7 |
102 | 2 | 2.7 |
102 | 3 | 2.7 |
103 | 1 | 1 |
103 | 2 | 1 |
Solved! Go to Solution.
Hi,
I assume the relationship is created like below.
Please check the below picture and the attached pbix file.
Story Points CC =
DIVIDE (
RELATED ( Story[Story Point] ),
COUNTROWS ( FILTER ( Sprint, Sprint[Story ID] = EARLIER ( Sprint[Story ID] ) ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I assume the relationship is created like below.
Please check the below picture and the attached pbix file.
Story Points CC =
DIVIDE (
RELATED ( Story[Story Point] ),
COUNTROWS ( FILTER ( Sprint, Sprint[Story ID] = EARLIER ( Sprint[Story ID] ) ) )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |