Forum Discussion
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 (endd...
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] )
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]
)