Split Column Value in another table

yogeshk77 — Tue, 28 Mar 2023 16:55:09 GMT

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

Re: Split Column Value in another table

Jihwan_Kim — Tue, 28 Mar 2023 17:19:32 GMT

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

topic Re: Split Column Value in another table in DAX Commands and Tips

Split Column Value in another table

Re: Split Column Value in another table