Power Query - Identifying Frequent Values
HTML-код
- Опубликовано: 14 окт 2024
- 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
github.com/jbo...
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 - Understa...