convert from hexadecimal value to number

BIXL - I created 2 functions that allow you to simply pass a hexadecimal value to fnHex2Dec2 in order to convert it to Decimal.

First one is basically the same as before:

let
    fnHex2Dec = (input) =>

let

values = {

{"1", 1},

{"2", 2},

{"3", 3},

{"4", 4},

{"5", 5},

{"6", 6},

{"7", 7},

{"8", 8},

{"9", 9},

{"A", 10},

{"B", 11},

{"C", 12},

{"D", 13},

{"E", 14},

{"F", 15}

},

Result = Value.ReplaceType({List.First(List.Select(values, each _{0}=input)){1}},type {number})

in

Result
in
    fnHex2Dec

2nd one is the one that you want to pass in your hex value to:

let
 fnHex2Dec2 = (input) =>

let

Reverse = List.Reverse(Text.ToList(input)),
DecimalValues = List.Transform(Reverse, each List.First(fnHex2Dec(_)) * Number.Power(16,List.PositionOf(Reverse,_))),
Return = List.Sum(DecimalValues)

in

Return
in
 fnHex2Dec2

Just makes sure that your input column is of type Text and then you can add a custom column like:

=fnHex2Dec2([Hex])

And you will get back the decimal value.