Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Product Serial number table based on input

Hi There,   I have two types of product serial number series ( 1> Alphanumeric 2> Numeric) with Starting and ending details in power BI tables. I want to generate a complete set of serial number t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi There,

 

These letters are not fixed, it varies based on production location.

 

Sanket 

MFelix's avatar
MFelix
Super User
4 years ago

HI Anonymous ,

 

Not talking about the lettter but the number of letters does it have different number of characters?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi MFelix,

     

    Number of characters will be same.

     

    Sanket

    • MFelix's avatar
      MFelix
      Super User
      4 years ago

      Hi Anonymous ,

       

      Sorry for another question but looking at your query and to the data you provided is the first table you provided a single table with repeating columns or did you paste two examples one in front of the other?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        MFelix,

         

        Regarding "Example input table" these are two different tables. One has alphanumeric values and the other has only numeric values, We have these two different styles of serial numbers, I want to generate both types of serial numbers.

         

        If possible (if Powe query has the ability) I would love to merge (append)  both the tables instead of having two different tables. 

         

        Thanks & Regards,

        Sanket