Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
Shadd307
Frequent Visitor

Creating a calculated column

So going for my second post hope help is as fast as the first one.

 

I am trying to create a new column in a table based on values in 2 other columns and then populating the new column with data from a 4th column. 

 

Here is an example of the data:

 

table = Gantt Chart table

If issue type = epic use parent link to find the parent-key in issue_key and then use the summary  of the parent_link and theparent_link value and populate it in a new column called parent_summary.

 

issue_keysummaryparent_linkissue_typeparent_summary (New column)
GDES-20654Do some work Story 
GDES-56713Build WaggleGDES-66684EpicGDES-66684: Waggle Launch
GDES-66684Waggle Launch Initiative 
GDES-56142test my work Story 
GDES-55651Build the widgetGDES-57785EpicGDES-57785: Widget Creation
GDES-57785Widget creation Initiative 
1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Shadd307 

Parent Summary = 
IF(
    'Table'[issue_type] = "Epic",
    VAR _parent_link = 'Table'[parent_link]
    VAR _summary = 
    CONCATENATEX(
        FILTER(
            'Table',
            'Table'[issue_key] = _parent_link
        ),
        'Table'[summary]
    )
    RETURN
    _parent_link & ": " & _summary
)


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@Shadd307 

Parent Summary = 
IF(
    'Table'[issue_type] = "Epic",
    VAR _parent_link = 'Table'[parent_link]
    VAR _summary = 
    CONCATENATEX(
        FILTER(
            'Table',
            'Table'[issue_key] = _parent_link
        ),
        'Table'[summary]
    )
    RETURN
    _parent_link & ": " & _summary
)


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.