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 fr...
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 🙂

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 🙂