Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
45
Views
Topic starter
How 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
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
