cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slounsbury
Helper II
Helper II

Comparing Values From Different Non-Related Tables

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

TicketNbrUrgencyIDSLA_RecIDResolution_Hours
12322272 
12322395 
12322474 

 

SR_SLAPriority Table

SR_RecIDUrgencyIDResolution_Hours
2710
2820
2930
5750
58100
59150
4720
4830
4940

 

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

TicketNbrUrgencyIDSLA_RecIDResolution_Hours
1232227210
12322395150
1232247420

 

1 ACCEPTED SOLUTION
Kevthebandit
Helper II
Helper II

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 

 

 

View solution in original post

3 REPLIES 3
HarrisonCbe
Resolver II
Resolver II

@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.

 

 

Kevthebandit
Helper II
Helper II

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 

 

 

View solution in original post

This worked great! Thank you.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors