Forum Discussion

ronnie_roberts's avatar
ronnie_roberts
Icon for Helper I rankHelper I
3 years ago
Solved

Return column from inactive relationship

I see plenty of ways to use an inactive table relationship to return a measure but I haven't seen anything about using an inactive table relationship to return a column.  Our Jira system provides a u...
Need Help
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Thanks 🙂

    If you are wanting to add a column to a table on the many-side of an inactive 1:many relationship with the User table, you can certainly use a pattern like that on the page linked above.

     

    Using the tables you posted, if you want to add a column to the Sprints table corresponding to Users[FullName] corresponding to FK_SprintOwner_ID, you could try:

    Sprint Owner Name (calc column) =
CALCULATE (
    MAXX ( Sprints, RELATED ( Users[FullName] ) ),
    USERELATIONSHIP ( Sprints[FK_SprintOwner_ID], Users[UserID] ),
    ALL ( Users )
)

    Adjust as necessary depending on the table/column names involved.

     

    Does something like this work?

    Regards

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
3 years ago

Thanks 🙂

If you are wanting to add a column to a table on the many-side of an inactive 1:many relationship with the User table, you can certainly use a pattern like that on the page linked above.

 

Using the tables you posted, if you want to add a column to the Sprints table corresponding to Users[FullName] corresponding to FK_SprintOwner_ID, you could try:

Sprint Owner Name (calc column) =
CALCULATE (
    MAXX ( Sprints, RELATED ( Users[FullName] ) ),
    USERELATIONSHIP ( Sprints[FK_SprintOwner_ID], Users[UserID] ),
    ALL ( Users )
)

Adjust as necessary depending on the table/column names involved.

 

Does something like this work?

Regards