How to Convert Serial number into SGTIN Format
Hi, I need to Convert Serial number into SGTIN Format in power bi. Can you please help me to achieve this. For Reference please find the attached pic.
Forum Discussion
amitchandak
Super User
Super UserAmitsaini89 , what is the logic? Is it like hexadecimal to decimal
https://xxlbi.com/blog/converting-hexadecimal-to-decimal-numbers-in-power-query/
vice versa
https://blog.crossjoin.co.uk/2018/09/23/converting-decimal-numbers-to-hexadecimal-in-power-query-m/
Hi amitchandak Thanks for the reply.
But it is not like converting hexadecimal to decimal, as you seen the serial numbers in the original post Pic, we need to convert that serial numbers[NestSn] into SGTIN format just like [hexanestsn-SGTIN] only in power bi. For SGTIN Format, please find the attched pic for reference.
