Forum Discussion
gargra
7 years agoRegular Visitor
Converting from Hex value to UTF8
Hi all, I am currently using the Power BI Desktop version, and trying to convert a column that contains values in Hex format to a simple string (UTF8). Is there a common easily available function...
v-yulgu-msft
Microsoft Employee
7 years agoHi gargra,
There is no direct function that can convert Hex value to decimal format. Please refer to below links to create custom function.
Power Query: Using Recursion to Solve Hex to Decimal Conversion
Power Query – Converting a hexadecimal number to decimal
Best regards,
Yuliana Gu
gargra
7 years agoRegular Visitor
Thanks for your reply v-yulgu-msft
Is there another custom function that i can use to convert the hex to a string format?
- v-yulgu-msft7 years ago
Microsoft Employee
Hi gargra,
What do you mean convert Hex to string? Can you show us some examples?
Regards,
Yuliana Gu