topic Last text value for column1 should be printed for all rows of column 2 in DAX Commands and Tips

Last text value for column1 should be printed for all rows of column 2

sjayawardana — Mon, 23 Nov 2020 04:15:37 GMT

Hi,

If the final status of each candidate = offered role, then Recruiter ideal result column should be= The recruiter relevant for offered role status.

Hope this is clear. Appreciate your help.

wdx223_Daniel — Mon, 23 Nov 2020 05:24:34 GMT

sjayawardana this works in a calculated column

amitchandak — Mon, 23 Nov 2020 05:57:01 GMT

wdx223_Daniel , Try a new column

maxx(filter(table, [Candidate] = earlier([Candidate]) && [Status] = "Offered role"),[Recruiter Full Name])

sjayawardana — Mon, 23 Nov 2020 06:27:09 GMT

Thank you all