Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.