Converting Hexadecimal to Decimal

[MarceloCunha04]

Hello,

I am looking for a way to get an hexadecimal value from external file and in Power Query to convert it to a number.

can't find the proper function for it...

for example the file value is : A174D2CA and after converting it from hex to number I'm expecting to get : 2708787914

Thanks

[vicky_ · Accepted solution]

Try the method Daniil has here: https://xxlbi.com/blog/converting-hexadecimal-to-decimal-numbers-in-power-query/