This video is a solution to the Excel BI Challenge Power Query 161
It's a deceptively tricky challenge and there are many ways to go about it. In this video I use df.groupby.apply with a custom function.
#data #excel #python #coding #analytics