Custom Column that returns Yes or No if the entry Date is Max for an ID number

[onernoa]

Hello

In Power Query I want to create a custom column that returns a yes or no for the MAX load_timestamp for each given cardId.

cardId	load_timestamp	Desired Column
1001	18/08/2022	Yes
1002	18/08/2022	Yes
1003	18/08/2022	Yes
1001	11/08/2022	No
1002	11/08/2022	No
1003	11/08/2022	No

Thank you in advance!

[bilalrana · Accepted solution]

Hi @onernoa,

Firstly you need to click on the Data Icon on the left border and open the table in which you want to put the Desired Column.

Now, paste the DAX forumla into formula bar and click on the Tick Icon.

Desired Column = 

var MaxTimestamp = CALCULATE (

MAX ( 'Table'[load_timestamp]),

ALLEXCEPT ( 'Table', 'Table'[cardId] )

 )

var result = if( 'Table'[load_timestamp] = MaxTimestamp, "Yes", "No")

return result

If this answers your question, please mark it as a solution!
 

[onernoa]

Many thanks. This has worked perfectly.