Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I am trying to change a value called "undergraduate research" to "research" in one column. The value "research" already exists in that column. When I make this change with the following replace function (= Table.ReplaceValue(#"Replaced Value","undergraduate research","research",Replacer.ReplaceText,{"Institution Labels Name"}) ), I see the value changed to "research" but it is identified as a different value than the original "research" (in the 1st image they are identified as different values). My goal was to have the counts by "research" and "research" (previously "undergraduate research") get added in a PowerBi visual (2nd image). I would like to know how to fix this, thank you for your help.
Perhaps you have hidden characters or leading/trailing spaces. Try doing a Clean or Trim on that column after you replace values.
Pat