cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
slounsbury Regular Visitor
Regular Visitor

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

Accepted Solutions
Kevthebandit Regular Visitor
Regular Visitor

Re: Comparing Values From Different Non-Related Tables

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
Kevthebandit Regular Visitor
Regular Visitor

Re: Comparing Values From Different Non-Related Tables

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

HarrisonCbe Member
Member

Re: Comparing Values From Different Non-Related Tables

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

 

 

slounsbury Regular Visitor
Regular Visitor

Re: Comparing Values From Different Non-Related Tables

This worked great! Thank you.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,428)