Forum Discussion
Amitsaini89
4 years agoFrequent Visitor
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.
v-yanjiang-msft
4 years agoCommunity Support
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.