Calculate Transactions From Multiple Files

So I am working on a data base that consists of multiple files, and would like to know if power BI can some how provide the information. Not looking for a 100% solution but directions/topics as to where I can find learning materials. I have a attached a below what the data set resembles. The File would be the differnt CSV files that will be put in the data folder for BI to populate. I would like to be able to do calculations based on the host ID that maybe on several files.