Power Query - Identifying Frequent Values

in this video i show you some tricks using list functions to identify Frequently or non Frequently used values in a dataset. i'll be using Stock Codes in various portfolio - so you can see how many times some stocks appear in a list of portfolios.
#data #dataanalysis #powerbi #powerquery #mquery #excel

Following Along file
https://github.com/jbotes/powerbiTutorials/blob/main/PQ_VALUE_ALL_COLUMNS_VIDEO.xlsx

Functions Used
List.Select - for selecting values in the list
List.Distinct - for only returning distinct values in a list
List.Combine - combine lists
List.Count - count items in list
Table.ToColumns - convert table into seperate lists
Table.Transpose - to transpose table columns into rows

Link to Referenced Video on Each and underscore
https://www.youtube.com/watch?v=WxWL3i05hZ0

Скачать видео