Forum Discussion
Helper VCleaning Data - Making Data ready for Power BI
I have some data that looks like this (sorry I can't show more) - It has some text for about 5 rows above the table and I have to combine data together from different files (20 or more) and on top of that the data is across diffferent sheets.
Need to combine into one sheet - I'm using power query and combine to try and speed this up - but I was wondering if anyone knew a quicker/better approach?
Regards,
Andrew
agd50 , Not very clear,
you can use merge or append to merge data
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Clean and trim to clean data:
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
Also check this powerful function addfuzzyclustercolumn
https://learn.microsoft.com/en-us/powerquery-m/table-addfuzzyclustercolumn
1 Reply
- amitchandak
Super User
agd50 , Not very clear,
you can use merge or append to merge data
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Clean and trim to clean data:
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
Also check this powerful function addfuzzyclustercolumn
https://learn.microsoft.com/en-us/powerquery-m/table-addfuzzyclustercolumn