Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm looking a way to replace text in a column in one query with mapped data in another. In the example below, I would want to replace all the names in Column1 with either Group1 or Group2 from Column2 (in Query2). I'm guessing I'll need to use the "Table.ReplaceValue" function. Is there a way to refer to other query tables in the formula syntax?
Many thanks!
Solved! Go to Solution.
Found the solution in these two very helpful videos:
Power Query: Bulk Replace Values from a table in Excel & Power BI - YouTube
(No/low code solution using merge)
Quick Tip - Replace value with another column in Power Query - YouTube
(Replacing nulls with text in another column)
Found the solution in these two very helpful videos:
Power Query: Bulk Replace Values from a table in Excel & Power BI - YouTube
(No/low code solution using merge)
Quick Tip - Replace value with another column in Power Query - YouTube
(Replacing nulls with text in another column)