Forum Discussion
Helper IIAdding Calculated Column To Table From Another Table
Hi Slounsbury
Noticed that you have many to many relationship between these tables. You may need to consider creating bridge table/ relationship table , which is explained in the below URL:
Hope this helps.
Thanks
Raj
Hi Slounsbury
1. In Retaionships Tab, define the relationship between Time_Entry_Table[SR_Service_RedID] = v_rpt_Service_Table[TicketNBR]
2. Now, create a new column using RELATE and use that measure in the v_rpt_Service_Table table.
New_Art_Feed= RELATE ( Time_Entry_Table[ART_FED]).
Hope this helps.
Thanks
Raj
Helper IIThank you for your reponse Anonymous
When I try to build the relationship between these two columns I get an error stating that they must have unique values. Any ideas on what could be cuasing this? I created a new table to get rid of the null values in the Sr_Service_RecID column. The SR_Service_RecID column eventually gest to ticket 284464 but the tickets before that are not needed. Should I delete the tickets that dont have a match in the other column?
Hi Slounsbury
Noticed that you have many to many relationship between these tables. You may need to consider creating bridge table/ relationship table , which is explained in the below URL:
Hope this helps.
Thanks
Raj