Easy fix help please!

[JD2301]

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 shows the site name.
I need to get the site name from the 'Timebase' table into the the 'Dispensations' table so I can refrence both the site and the site unique ID (along with a few other things).

This sounds simple and I imagine it is so please could anyone help me out? I've never used the measures before!

TIA.

JD.

[Anonymous]

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.