Forum Discussion
Data Relationship Help!
The easiest way would just be to link the tables by the project name. The only issue is if you have multiple lines with that same project name in each table. To get around, that you can create a "bridge" table. Just make a list of unique project names and then link both of the other tables to the "bridge".
benjamincoady : you can create a view if you have having database (MS Access ) and pull into powerbi and write your measures that is the simple way to achieve it .
Else in edit query window you will have the option of append queries can you trying merging your data into single and then perform the calcualtions else it will be difficult if you are having many files from all over persons . can you check these two options .
Really sorry, I'm struggling to understand your typed English....