Forum Discussion
Calculating Min date and Max date from multiple date columns for each row in Power query.
Finding Min(Start) date and Max(End) for below sample data- For each Row. Some of the dates will be blank as well NPI Program P/n count est Mfg Facility Location Launch GW1 GW2 GW3 PD1...
Hi Anonymous ,
Try these calculations in new custom columns:
// Start Date List.Min({[Launch], [GW1], [GW2], [GW3]... }) // End Date List.Max({[Launch], [GW1], [GW2], [GW3]... })Pete
Hi CNENFRNL ,
I like this solution, much tidier than mine, but I can't seem to work out how this only picks out the dates for evaluation nad no other values/numbers.
In OP's example data, there is a field that just contains the number 12. How is that not lower than the integers behind the date fields?
Hope this makes sense.
Pete
Hello, my friend, for a formula
List.Min({"ABC", 10, #date(2021,11,18), null})I'm sure that string and null value are to be skipped; but frankly speaking, I didn't know why the result is #date, rather than 10.
I turned one of my friends for help in the hope of some clue.