Forum

How to add a column...
 
Notifications
Clear all

How to add a column with a value based on the first value of a column?

2 Posts
2 Users
0 Reactions
84 Views
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

Add-a-value-based-on-the-first-value-of-a-column_2.JPGHow can I to add a column with a value based on the first value of (or the minimum value) a column?

 
Posted : 30/07/2020 4:52 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Jim,

You can use List.Min in a Custom Column for this. I can't reference the screenshot because it's too small and therefore unreadable, but it should be something like this:

=List.Min(#"Step Name"[Column Name])

The #"Step Name" is the step name prior to the custom column that you want to add and the Column Name is the name of the column you want to find the minimum of.

Mynda

 
Posted : 30/07/2020 7:08 pm
Share: