Best way to merge similar data from different sources
PBI Noob here again.
My next issue is I have 3 or 4 systems that capture the "same" data differently. More specifically for me its slight difference in location names. Example..
North West Sydney Shed 231
Art Gallery Shed
8453 - The Pickle Shop - 544
If I wanted to manipulate/filter data based on "Shed 231" is it better to create multiple measures and then join them into one larger measure? Or is there a way to make PBI understand that North West Sydney Shed 231 = Shed 231 & Art Gallery Shed = Shed 231?
I'd also check out the fuzzy match on the merge, I used it to solve a similar problem recently.
If you have the sources in 3 different tables, you could create duplicates of each with just the locations. Then merge with fuzzy match into a new table. That table will have three columns matching all the locations. You can bring that table into your data model, then connect up the three source tables to their matching location column. (Hide the three duplicates with only locations). Now you can use any of the columns as a slicer in your report.
The one that was tricky with the example you gave was ThePickleShop -- it wasn't able to match until I added spaces before the capitals.