Changing Dates as Column Names to the Month using Power Query

[programsam]

Greetings,

A bit of a noob with PQ and have a file that comes through weekly where the oldest month falls off when we enter a new month and the new month climbs in. What I'm trying to accomplish is to change the date to the MONTH NAME instead. As example, the first column in the image below would read JULY, the second would read as AUGUST, etc.

 

[RoryA]

You can add a step using Table.TransformColumnNames like this:

= Table.TransformColumnNames(Source, each try Date.MonthName(Date.From(_)) otherwise _)

(this assumes that Source was the previous step)