Forum Discussion
Military Power BI Question
Here is a link to the type of Data I am using. I want to be able to combine both sheets and have it created in Power BI where I can track each soldier slotted in each position and see where (if any) vacancies are, as well as start and stop dates of each position.
Hi,
In order tie together tables we need to have what we call primary key in one table and and foreign key in another table. I have noticed you have TRAP in both tables and locations in both tables as well -- TRAP UIC (repeating values) and TRAP NUMBER (unique values).
Do these fields provide unique identification to their records in their respective databases ?
In the data set you presented, are these TRAP ids unique to thier databases or not??? For example, will DMO 1585A from database 2 also exist in database1 ?
Databse 1
| location |
| TRAP UIC |
Database 2
| TRAP NUMBER |
| LOCATION |