Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Hi @Amitsaini89 ,
Haven't found the function in Power BI. From the data you displayed, if Serial Number and SGTIN Format differ only by the last digit, you just need to replace value in Power Query.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Amitsaini89
What is the logic to convert it? Would you consider that not only we try to find the ways of conversion but also logic for converting SGTIN searching over google, as I did and found some link below:
https://www.epc-rfid.info/sgtin
it is too hard to first find the logic ourselves, right!
@Amitsaini89 , 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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 40 | |
| 21 | |
| 18 |