Forum Discussion
Add Date Column Using Power Query
Hi all, I am trying to work through survey data for a restaurant and am having trouble transforming the data. Currently, the raw data looks like this (as they are combined from multiple surveys): ...
Duplicate the table.
In Table1, remove the rows with 'actiondate' in Attribute (by filtering from column header)
In Table2, keep only the rows with 'actiondate' in Attribute (by filtering from column header)
--
Merge Table1 and Table2 on SurveyID and expand the new column to return the date
HotChilli
Community Champion
Community ChampionDuplicate the table.
In Table1, remove the rows with 'actiondate' in Attribute (by filtering from column header)
In Table2, keep only the rows with 'actiondate' in Attribute (by filtering from column header)
--
Merge Table1 and Table2 on SurveyID and expand the new column to return the date