Solved: Grouping

Anonymous · ‎05-08-2019

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 · ‎05-09-2019

@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]
)

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎05-09-2019

@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]
)

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.