Custom column - return result of a field based on max date for each unique id

[Winter_king94]

Hi, 

I am trying to create a column that populates the campaign name that has the max create date for each id. Below is an example of the data set and the ideal end result. There are some campaigns that have the same created date but a different time stamp as well. 

I was able to make a measure that populated the campaign name correclty but am unable to figure out how to make a column that does the same.

Below is the measure I made:

Max CR Name = CALCULATE(FIRSTNONBLANK('campaignresponse'[Parent Campaign],1),

Filter('campaignresponse', 'campaignresponse'[createdon_CDT] = 'campaignresponse'[CR Max Date.MAX CR Date]))

[v-tangjie-msft · Accepted solution]

Hi @Winter_king94 ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create calculated columns.

Column = 
var _max_date=CALCULATE(MAX('Table'[Created Date]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])))
RETURN CALCULATE(MAX('Table'[Campaign Name]),FILTER('Table',[ID]=EARLIER('Table'[ID]) && [Created Date]=_max_date))

Column 2 = 
CALCULATE(MAX('Table'[Created Date]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])))

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.