Is there a way to remove chinese texts in Power BI using Power Query or DAX?

[Anonymous]

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?

[Vijay_A_Verma · Accepted 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)))

[Anonymous]

Worked like a charm! Thank you, Mate.