Comparing Values From Different Non-Related Tables

[slounsbury]

Hi All, I have a query that I can't seem to figure out. Do to one of my tables having information and not having a relationship with other I wanted to see if there is someway I could compare the two tables to get the information I am wanting. This doesn't explain it well so I will post what I am wanting.

SR_Service Table

TicketNbr	UrgencyID	SLA_RecID	Resolution_Hours
123222	7	2
123223	9	5
123224	7	4

SR_SLAPriority Table

SR_RecID	UrgencyID	Resolution_Hours
2	7	10
2	8	20
2	9	30
5	7	50
5	8	100
5	9	150
4	7	20
4	8	30
4	9	40

Basically what I am wanting is to create a new column in the first table to compare the frist two values with the second table and pull the resolution hours. Is that possible like this:

SR_Service Table

TicketNbr	UrgencyID	SLA_RecID	Resolution_Hours
123222	7	2	10
123223	9	5	150
123224	7	4	20

[Anonymous]

@slounsbury you should try the function LOOKUPVALUE, in this link there's a explanation of how it works

https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/

I hope it helps you.

[Anonymous · Accepted solution]

You should try to relate them. What I would do is create a composite key by concatenating two fields into 1 and joining the two tables together on the newly created fields.

UrgencyId & SLA_RecID = 7 &"|"& 2

UrgencyID & SR_RecID = 7 &"|"& 2 

[slounsbury]

This worked great! Thank you.