Forum Discussion
Help linking tables please!
Hi all, I'm pretty new to BI so looking for some help with what I think should be a simple task.. I have a 'Dispensations' table that shows a sites unique ID. I have a 'Timebase' table which ...
does your timebase table also have the site Unique ID? If so, you can create a relationship between the 2 tables on this ID that will then allow you to present data from different tables.
-This is provided you don't have other relationships between this tables already.
If this is the case, I would consider creating a reference table with the ID and name as a standalone table and then creating seperate relationships.
-There is probably more complicated ways to do it, but these are the 2 simpler (longer maybe) options I would use in this case.