Here's a cool #PowerQuery technique to merge multiple files with properties from the file in the output. Imagine you have files with transactional data saved with the month as the file name, but no date records. Here's how to merge and inject the filename:
#PowerQuery