Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ironpink
Frequent Visitor

add a column with the minimum date in a group

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

 

ITEMData_checkEventNEW_COLUMN
ITEM_0131/03/2022Event_0431/03/2022
ITEM_0120/06/2022Event_0431/03/2022
ITEM_0120/09/2022Event_0431/03/2022
ITEM_0120/12/2022Event_0431/03/2022
ITEM_0130/03/2023Event_0431/03/2022
ITEM_0120/06/2023Event_0431/03/2022
ITEM_0120/09/2023Event_0431/03/2022
ITEM_0120/12/2023Event_0431/03/2022
ITEM_0120/03/2024Event_0431/03/2022
ITEM_0120/06/2024Event_0431/03/2022
ITEM_0120/09/2024Event_0431/03/2022
ITEM_0120/12/2024Event_0431/03/2022
ITEM_0120/03/2025Event_0431/03/2022
ITEM_0120/06/2025Event_0431/03/2022
ITEM_0122/09/2025Event_0431/03/2022
ITEM_0122/12/2025Event_0231/03/2022
ITEM_0223/08/2022Event_0323/08/2022
ITEM_0223/08/2022Event_0323/08/2022
ITEM_0223/08/2023Event_0323/08/2022
ITEM_0223/08/2024Event_0323/08/2022
ITEM_0225/08/2025Event_0323/08/2022
ITEM_0224/08/2026Event_0323/08/2022
ITEM_0230/08/2027Event_0223/08/2022
ITEM_0323/05/2022Event_0323/05/2022
ITEM_0322/05/2023Event_0323/05/2022
ITEM_0321/05/2024Event_0323/05/2022
ITEM_0321/05/2025Event_0323/05/2022
ITEM_0321/05/2026Event_0323/05/2022
ITEM_0328/05/2027Event_0223/05/2022

 

ironpink_0-1641839773144.png

 

 

tx for any help

1 ACCEPTED SOLUTION
ironpink
Frequent Visitor
5 REPLIES 5
ironpink
Frequent Visitor

smpa01
Super User
Super User

@ironpink 

measure = calculate(min(tbl[Data_check]),allexept(tbl,tbl[item]))
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

there's something wrong. 

can you help me?

 

 

ironpink_0-1641845634855.png

ironpink_2-1641845664632.png

thank you

raffaele

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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

ironpink_0-1641846672082.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.