Forum Discussion

LiquidMetal's avatar
LiquidMetal
Frequent Visitor
3 years ago
Solved

Model View Compound Key Relationship

I have loaded two tables into Power BI Service.   I will need to join the two tables with two fields from each table.  So far, this seems like this is not possible.  Therefore, I have joined the tw...
General Comment
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi LiquidMetal 
    There are a few methods to merge tables by multiple columns :
    1. To concatenate columns an create a relationship by concatenated column (like you did on SQL)
    2. Ro merge tables to one by multiple from PQ

    3. Using TREATAS DAX Function.
    For more details please refer to the linked video:
    https://www.youtube.com/watch?v=WrwTCbKxG7U&t=860s
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi LiquidMetal 

    1. Right.

    2 Every solution has its perfomance costs...

    You can check them with dax studio

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi LiquidMetal 
There are a few methods to merge tables by multiple columns :
1. To concatenate columns an create a relationship by concatenated column (like you did on SQL)
2. Ro merge tables to one by multiple from PQ

3. Using TREATAS DAX Function.
For more details please refer to the linked video:
https://www.youtube.com/watch?v=WrwTCbKxG7U&t=860s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly