Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi! I need to remove the chinese texts from the values of certain fields. Is there a way to do this in Power Query or DAX?
Solved! Go to Solution.
Use this in a custom column (or use this logic in Table.Replace). Replace [Text] with your column name.
Text.Select([Text], List.Transform({0..255}, (x)=>Character.FromNumber(x)))
Use this in a custom column (or use this logic in Table.Replace). Replace [Text] with your column name.
Text.Select([Text], List.Transform({0..255}, (x)=>Character.FromNumber(x)))
Worked like a charm! Thank you, Mate.