Forum Discussion
Hex to Binary conversion (helping function provided from another post)
I am receiving data for the operation of some sensors which is in Hex format. In order to see which sensor is on and which is off, I need to convert this into Binary, thus know which sensors are on...
Hi Anonymous ,
By my research, I'm afraid that we cannot convert hex to Binary directly in power bi.
You'd better convert hex to number and then convert number to binary as a workaround.
Here are two thread you could refer to.
https://www.excelandpowerbi.com/?p=291
https://community.powerbi.com/t5/Desktop/Number-to-Binary/m-p/235261#M104739
Best Regards,
Cherry
Hi Anonymous ,
By my research, I'm afraid that we cannot convert hex to Binary directly in power bi.
You'd better convert hex to number and then convert number to binary as a workaround.
Here are two thread you could refer to.
https://www.excelandpowerbi.com/?p=291
https://community.powerbi.com/t5/Desktop/Number-to-Binary/m-p/235261#M104739
Best Regards,
Cherry