Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouping

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:


General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

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

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

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