Press "Enter" to skip to content

Removing Characters Before or After a Delimiter in Power Query

Gilbert Quevauvilliers shows how to remove all characters either before or after a delimiter:

This is an example of what my column name looked like below.

Date[Yr-Mth]

What I wanted this to look like is Yr-Mth]

Below is the Syntax I used to get this working.

Click through to see how Gilbert was able to do this and subsequently how to get rid of the trailing bracket.