Скачать или смотреть Power Query - ID all stocks for season

in datasets where you have to idenitfy items that appear consistently across all months (seasons) in a year this power query pattern illustartes how you can get the answers with the help of group and list functions.
#data #dataanlytics #dataanalysis #powerbi #powerqueryeditor #mquery #excel #powerbidesktop

File Link
https://github.com/jbotes/powerbiTuto...

Functions used
Table.Group to group the data
List.Transform to convert a list of dates to months
List.Distinct to remove duplicate months in list
Date.Month to extract the month only from a date
List.Count to count the number of months for each stock
Table.SelectRows to filter the number of months for all seasons

Noteworthy things:
Used a paramater table to feed into the main query