Forum Discussion
Helper IIJoining and filtering data from multiple sources
That's strange. I just copied it again and it was exactly the same as last time. I think it is a forum page issue (this forum does strange things sometimes). Anyway, I have updated the link and it now works.
Community ChampionHere is the general process.
Import table 3 and load it to power bi. This will be your lookup table
load table 1 and set it so it doesn't actually load (connection only).
Load table 2 the same way as 1
merge table 1 & 2 together then load to power bi. This is your data table
join the data table to the lookup table using post code. You can then get total sales by rep name
is this enough to help you? Do you know how to do these things?
JClisheThanks for the reply! Yes that definitely helps although no, I don't yet know how to do those things (although I'm learning).
- MattAllington
IT would take a long time to type an explanation. Much easier just to show you - here is a video.
https://dl.dropboxusercontent.com/u/30711565/how%20to%20join%20tables.wmv
- JClishe
Thank you! Unfortunately that link isn't working.