Convert column with hexadecimal to decimal

Question

Hello,&nbsp;&nbsp;is there a simple way to convert a column with hex numbers to decimal nummers?&nbsp;I have a file which is always in this format with 8 columns of hexadecimal numbers.https://www.dropbox.com/s/0yi38mvkj5geecx/Clipboard02.jpg?dl=0&nbsp;Thank you!&nbsp;Marcel

shumie · Answer

I mean column 7 to 14 which are always decimal 0 to 255.

v-cherch-msft · Answer

Hi&nbsp;Shumie&nbsp;You may try to use M language in Advanced Editor. Here is the reference for you.&nbsp;https://community.powerbi.com/t5/Desktop/convert-from-hexadecimal-value-to-number/td-p/28435&nbsp;Regards,Cherie

Forum Discussion

Convert column with hexadecimal to decimal

2 Replies

Related content

Converting Hexadecimal to Decimal

Convert time (hh:mm) to decimal

Can't convert text to decimal

convert from hexadecimal value to number

Convert hexadecimal ip address to decimal dotted from TMG