add a column with the minimum date in a group

[ironpink]

Hi all

I need to create a column (power bi desktop -> power query -> custom column) with the minimum date based on the content of another column. here what I have and what I wish

ITEM	Data_check	Event	NEW_COLUMN
ITEM_01	31/03/2022	Event_04	31/03/2022
ITEM_01	20/06/2022	Event_04	31/03/2022
ITEM_01	20/09/2022	Event_04	31/03/2022
ITEM_01	20/12/2022	Event_04	31/03/2022
ITEM_01	30/03/2023	Event_04	31/03/2022
ITEM_01	20/06/2023	Event_04	31/03/2022
ITEM_01	20/09/2023	Event_04	31/03/2022
ITEM_01	20/12/2023	Event_04	31/03/2022
ITEM_01	20/03/2024	Event_04	31/03/2022
ITEM_01	20/06/2024	Event_04	31/03/2022
ITEM_01	20/09/2024	Event_04	31/03/2022
ITEM_01	20/12/2024	Event_04	31/03/2022
ITEM_01	20/03/2025	Event_04	31/03/2022
ITEM_01	20/06/2025	Event_04	31/03/2022
ITEM_01	22/09/2025	Event_04	31/03/2022
ITEM_01	22/12/2025	Event_02	31/03/2022
ITEM_02	23/08/2022	Event_03	23/08/2022
ITEM_02	23/08/2022	Event_03	23/08/2022
ITEM_02	23/08/2023	Event_03	23/08/2022
ITEM_02	23/08/2024	Event_03	23/08/2022
ITEM_02	25/08/2025	Event_03	23/08/2022
ITEM_02	24/08/2026	Event_03	23/08/2022
ITEM_02	30/08/2027	Event_02	23/08/2022
ITEM_03	23/05/2022	Event_03	23/05/2022
ITEM_03	22/05/2023	Event_03	23/05/2022
ITEM_03	21/05/2024	Event_03	23/05/2022
ITEM_03	21/05/2025	Event_03	23/05/2022
ITEM_03	21/05/2026	Event_03	23/05/2022
ITEM_03	28/05/2027	Event_02	23/05/2022

tx for any help

[ironpink · Accepted solution]

here's what I need

https://www.youtube.com/watch?v=hidJ5T_DYQ0

[smpa01]

@ironpink 

measure = calculate(min(tbl[Data_check]),allexept(tbl,tbl[item]))

[ironpink]

there's something wrong. 

can you help me?

thank you

raffaele

[smpa01]

@ironpink  this is a DAX measure which is not to be used as POWER QUERY expression

[ironpink]

so, how can I add a column here with the data above asked?