When combining multiple Excel files using Power Query, it is often difficult to identify which file each row originally came from. This becomes more complex when identical values exist across multiple files. In such cases, simply keeping the maximum value is not enough to track the data source. This tutorial explains how to retain source filenames and combine them when duplicate maximum values e..
