DAX: Cannot get date value to copy over to new column compared to another value

[Anonymous]

Hello,

I have a column called "GB Cert Date" that should only have one value per person (i. e. sorted by ID, each person has multiple rows but only one of them has this date) and my code works when I put "test", but whenever I want to copy over the date and have it filled to the rest of the user's rows, it only goes into one column.

GB Test Cert Date = 
var _cnt = countx(filter('DRMRecords', [User ID] = earlier([User ID])), [User ID])
var _cntc = countx(filter('DRMRecords', [User ID] = earlier([User ID]) && [IsGBCertRelated] = "Y"), [User ID])
var _date = FIRSTNONBLANK(DRMRecords[GB Cert Date],MIN([GB Cert Date]))
return


Switch(true() ,
 _cntc > 0, _date,
 BLANK()
 )

It comes out as:

GB Cert Test Date

10/10/2017

-----------------

With "test" instead of _date
GB Cert Test Date
Test

Test

Test

Test

What I want:

GB Cert Test Date

10/10/2017

10/10/2017

10/10/2017

10/10/2017

Anyone know how I can produce this result?

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

GB Test Cert Date Column = 
  IF(
    ISBLANK([GB Cert Date]),
    MAXX(FILTER('Table',[User ID] = EARLIER('Table'[User ID])),[GB Cert Date]),
    [GB Cert Date]
  )