Forum Discussion
JoeCrozier
Helper II
Helper IIAdd suffix to column in Power Query if duplicates
Hello! I have data that looks like this: I want to pivot it to look like this: I.e. "completed date"'s become the values for the rows of protocol id's and columns of milestones. ...
I think that's just telling you it doesn't know what [Data] is in that line.
Just from observation, it looks like the formula has been entered directly in the formula bar instead of in the Add Custom Column dialog. I'm sure it will get wrapped with a reference to the previous query step if you do that.
HotChilli
Community Champion
Community ChampionI think that's just telling you it doesn't know what [Data] is in that line.
Just from observation, it looks like the formula has been entered directly in the formula bar instead of in the Add Custom Column dialog. I'm sure it will get wrapped with a reference to the previous query step if you do that.
JoeCrozierHelper II
Helper IILol. It was as simple as that, thank you.