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
MFelix's avatar
MFelix
Super User
4 years ago

Hi Anonymous ,

 

This is better to be solved in Power Query however I have a doubt that is you start and end serial have different number of lines whast is the value you want in the end example in the first line the first serials have 469 lines (DD1A1923000996 - DD1A1923001465) and in the second part they have 129 lines (1922000011 - 1922000140)

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?