Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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 |
Solved! Go to 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 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.
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
This worked great! Thank you.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 51 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 134 | |
| 111 | |
| 50 | |
| 31 | |
| 29 |