Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago
Solved

hi

hi,

 

am i not sure its and excel work or i can do it using power bi. 

We have same invoice number for multiple product bar code. as per following view. 

 

i want to arrange Invoice_no and user_barcode side be side with same invoice number. 

i.e

 

invoice_no                USER_BARCO

2016078182442-       36004, 36005

2016070116825-       10009, 10011, 10012

2016070116700-       10001

 

like this format. 

i have more than 5 million data to do please advise the best and quick way to achive this

thanks

Need Help

10 Replies

    • abc_777's avatar
      abc_777
      Solution Specialist
      3 years ago

      Ahmedx 

      one last thing after convert user barcode how i can i export data to csv from power query as its a large data set of 50,00,000. i tried dax studio it can do only upto 4,00,000 how i can take full data

      thx

      • Ahmedx's avatar
        Ahmedx
        Super User
        3 years ago

        you may have to split the table into several parts with the help of Table.Range() and then export with the help of Bravo for Power BI . this tool can export up to 1 million

    • abc_777's avatar
      abc_777
      Solution Specialist
      3 years ago

      Hi   Ahmedx 

       the magnitude of data set would be two columns product name and Invoice_no with 3 million of rows or data

       

       

      can i do the followng code at MSSQL rather using power bi. so work would be much easier.

      If so pelase instruct me how and the syntex. 

       

      = Table.Group(Source, {"INVOICE_NO"}, {{"Count", (x)=> Text.Combine(x[USER_BARCC],", ")
}})

       

       

      thanks man

      u help me a lot

       

      • abc_777's avatar
        abc_777
        Solution Specialist
        3 years ago

        its k man, thanks again you helped me a lot