Adding Calculated Column To Table From Another Table

[slounsbury]

I have created a calculated column (ART_FET) in a table (Time_Entry) and am needing to move that column into another table (v_rpt_service). The two columns dont have any similar column titles but they do have a ticket number column that is just named differently in each (SR_Service_RecID and TicketNbr). I am wantting to join the ART_FET column to the v_rpt_service table by referencing the SR_Service_RecID and TicketNbr.

Here is an example of what I am looking for, The column in bold is what I am wanting to move.

Time_Entry Table

SR_Service_RedID	ART_FED
123456	11/5/17 7:30 PM
123456	11/6/17 7:30 PM
123456	11/7/17 7:30 PM
987654	11/8/17 7:30 PM
987564	11/9/17 7:30 PM
987654	11/10/17 7:30 PM
v_rpt_service Table
TicketNBR	Entered_By	Time_Start_UTC	Time_End_UTC	First_Time	ART_FED
123456	joe	11/6/17 8:30 PM	11/6/17 9:30 PM	11/6/17 8:30 PM	11/5/17 7:30 PM
123456	bob	11/7/17 10:30 PM	11/7/17 11:00 PM	11/6/17 8:30 PM	11/6/17 7:30 PM
123456	tim	11/8/17 6:30 PM	11/8/17 7:00 PM	11/6/17 8:30 PM	11/7/17 7:30 PM
987654	bob	12/6/17 6:30 PM	12/6/17 7:00 PM	12/6/17 6:30 PM	11/8/17 7:30 PM
987564	joe	12/12/17 9:30 PM	12/12/17 10:00 PM	12/6/17 6:30 PM	11/9/17 7:30 PM
987654	tim	1/11/18 6:30 PM	1/11/17 7:00 PM	12/6/17 6:30 PM	11/10/17 7:30 PM

[Anonymous]

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

[slounsbury]

Thank 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?

[Anonymous · Accepted solution]

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:

https://community.powerbi.com/t5/Report-Server/Many-to-Many-Relationship-between-tables-and-show-dat...

Hope this helps.

Thanks

Raj