Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.