If the person asking for the combined data wants any analysis by month, you’ll need to add it. So, let’s do that next: Power Query adds the new column. We’ll add the month to each data set ...

When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.

Custom functions in Power Query enable you to replicate transformations ... If you need to modify the transformations—such as adding a new column, changing a filter, or updating a calculation ...