Find & Replace, Group By 3 Columns, Load With Existing Connections
See how to:
(00:08) Problem Set up. Also Discussion about how sometimes Power Query can be better than Formulas.
(01:00) Build Query with Find & Replace using “Find Values” feature in the Transform Group in the Home Ribbon Tab
(01:32) Use Group By three columns for Date, Employee and Region Columns
(02:46) Change Date Type and mention November Power Query Update Error
(03:13) Close and Load To Table, Which Gives a Date Number Format Error
(03:30) Add Records to Table and See: 1) Query Updates with Find and Replace and incorporates New Regions, and 2) Date Number Formatting is incorrect because of November Power Query Update Error.
(05:21) Work Around for November Power Query Update Error. Trick comes from Daniel Dion: Rather than loading to a Table from inside Power Query, You can load to A Connection Only, then Load a Table from Data Ribbon Tab, Get External Data, From Existing Connections.