Forum Discussion
Merging multiple rows into one based on date values
Hi arnaudmanir
I think you want to look into using the table.group function. Table.Group - PowerQuery M | Microsoft Learn
When it comes to showing [second advance date], [second payout day] do you want to show these is separate columns? If so you might want to duplicate the relevant columns first and then use the group function with the correct aggregation to show the second or third etc. values.
Hope this helps!
Hi arnaudmanir
I think you want to look into using the table.group function. Table.Group - PowerQuery M | Microsoft Learn
When it comes to showing [second advance date], [second payout day] do you want to show these is separate columns? If so you might want to duplicate the relevant columns first and then use the group function with the correct aggregation to show the second or third etc. values.
Hope this helps!
It helped immensely, thanks a bunch. I used min and max aggregate on the advance date column to filter for the initial and the latest advance date. To expand on that, how can I see dates in between those two dates? I know List.Min will show the first and List.Max the latter, but what about the in betweens? Hope I'm making sense.
