Using Power Query Advanced Editor & M Functions


The first thing that I’m going to do is split that text column. So we’ll use the function, Text.Split, and then place an opening parenthesis. It wants a text, so we can point to our Text column. Next, it wants a separator as text. So in between a set of double quotes, we can add that semi-colon, then close the parenthesis, and press OK.
To read the full blog click on the foloowing link
https://blog.enterprisedna.co/....using-power-query-ad

#business