Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
is there a simple way to convert a column with hex numbers to decimal nummers?
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
Thank you!
Marcel
I mean column 7 to 14 which are always decimal 0 to 255.
Hi @Shumie
You may try to use M language in Advanced Editor. Here is the reference for you.
https://community.powerbi.com/t5/Desktop/convert-from-hexadecimal-value-to-number/td-p/28435
Regards,
Cherie
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |