Forum Discussion

yogeshk77's avatar
yogeshk77
Helper I
3 years ago
Solved

Split Column Value in another table

Hi,
I have a two tables

Story Table

Story IDStory Point
1015
1028
1032
10413

 

Another one is a mapping of Story & Sprint Table, where one story may belong to more than one sprint

Story Sprints

Story IDSprint ID
1011
1012
1021
1022
1023
1031
1032

 

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 IDSprint IDStory Points
10112.5
10122.5
10212.7
10222.7
10232.7
10311
10321
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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] ) ) )
)

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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] ) ) )
)