Grouping

[Anonymous]

I have data that looks like this:

So a single company (co) can have multiple owners (code) over time. I am trying to find a way so that if a company has a code of 'CentrallyHR', the (enddate) column for the entire company, not just the row with 'CentrallyHR', = 12/31/2100. Here's the calculated column I have, I just don't know how to modify to get what I'm looking for:

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the DAX below.

Column =
IF (
    CONTAINS ( Table1, Table1[co], Table1[co], Table1[code], "CentrallyHR" ),
    DATE ( 2100, 12, 31 ),
    Table1[enddate]
)