Forum Discussion
Combine Function from csv in folder
I have a structure of folders than all contain .csv files in the same format. Using folder as the data source Power Bi does a reasonable job of transforming the data. Each file has data in the f...
Himarkpendlebury ,
You will have to try using Table.SelectRows along with Text.Contains to filter the *SOF* and *EOF* records.
If you upload the pbix file to Google or OneDrive and share the link here to give you the right solution.
Cheers
CheenuSing