The Table.Group function can do incredible things like dynamically grouping based on a comparer function just using the 4th and 5th optional arguments of the function. In this video i demonstrate the function in action.
#dataanalysis #data #excel #powerquery #powerbi #powerbidesktop
The Following along file can be found here:
https://github.com/jbotes/powerbiTutorials/blob/main/PQ_Portfolio_Comparer_Video.xlsx