POWERBI DAX

Hi Anonymous 

 

Download example PBIX with code

 

Do you just need this conversion for 2 digit hex numbers?  This code works only for 2 digits as shown in your example but can be expanded for more digits.

Firstly, create a new table 

 

HexTable = {
                ("0", 0),
                ("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)
                }

 

 

Rename the text column Hex and the numeric column Decimal

Then create a column in your table containing the hex - change the VAR statements with 'Table'[Hex] to match your own table and column names.

 

HexToDecimal = 

VAR _FirstHexDigit = RIGHT('Table'[Hex],1)
VAR _SecondHexDigit = MID('Table'[Hex],3,1)

RETURN 

LOOKUPVALUE('HexTable'[Decimal],'HexTable'[Hex], _SecondHexDigit)*16 + LOOKUPVALUE('HexTable'[Decimal],'HexTable'[Hex], _FirstHexDigit)

 

Regards

Phil