Forum Discussion

Shadd307's avatar
Shadd307
Frequent Visitor
4 years ago
Solved

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 
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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 🙂

1 Reply

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    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 🙂