Forum Discussion

JD2301's avatar
JD2301
New Member
7 years ago

Easy fix help 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 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.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.