Forum Discussion
Data Filtering by Column/ Horizontal
I have date in 1st column and names in 2nd, 3rd, 4th column and so on. How can I filter a data to get the count of each name in the specified date range. Enclosed excel file with data an...
Looks good to me. About the only point where I would differ is in that I would have converted the named range to a Table before starting with PQ. That both makes the input dynamic and saves the promote headers step in the M code.
PeterBartholomew1 Good point. Will keep that in mind!