Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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:
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
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |