Power Query - Identifying Frequent Values скачать в хорошем качестве

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/powerbiTuto... 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    • Power Query - Understanding each and under...