Power BI Functions — Table.ColumnNames, List.Select and List.Count

Photo by CHUTTERSNAP on Unsplash

Finding relevant tables to work with within a bunch of CSVs can be very difficult. Finding these files with little to no documentation can be time consuming, and typically involves browsing through the column names of each CSV.

I was recently working on a project that contained many CSVs. I only wanted to use the CSVs that contained a certain column…