cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
yogeshk77
Helper I
Helper I

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
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I assume the relationship is created like below.

Please check the below picture and the attached pbix file.

 

 

Jihwan_Kim_0-1680023822348.png

 

 

Jihwan_Kim_1-1680023924023.png

 

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.


Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

I assume the relationship is created like below.

Please check the below picture and the attached pbix file.

 

 

Jihwan_Kim_0-1680023822348.png

 

 

Jihwan_Kim_1-1680023924023.png

 

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.


Go to My LinkedIn Page


Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors