Comparing periodic reports

These one should help you how to do

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/

Hi Anonymous , 

If you want to combine two excel into the same, I think you need to make sure two excels' data strcture and data type are the same, then when you combine, it shoud work. For combine, you could refer to above links.

Or if the excel files are different(like fact table, date table), you could import excel files in it, then create relationship between them based on key column and create measure.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

Additionally, you should also convert the text date into a proper date.  Then build a Calendar Table and create a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  To your visual, you should drag the Date column from the Calendar Table.