Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to join two tables with multiple common fields but no unique identifier

Hi, I'm still quite new to Power BI especially with the modeling part.    I'm trying to join a table called LeadTimeGrid with the following columns: CUSTOMER REGION FACTORY STANDARD LEAD TIM...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    you can just create a column

    Column = maxx(FILTER(LeadTimeGrid,'Fact'[CUSTOMER]=LeadTimeGrid[CUSTOMER]&&'Fact'[REGION]=LeadTimeGrid[REGION]&&'Fact'[FACTORY]=LeadTimeGrid[FACTORY]),LeadTimeGrid[STANDARD LEAD TIME])

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Anonymous 

you can just create a column

Column = maxx(FILTER(LeadTimeGrid,'Fact'[CUSTOMER]=LeadTimeGrid[CUSTOMER]&&'Fact'[REGION]=LeadTimeGrid[REGION]&&'Fact'[FACTORY]=LeadTimeGrid[FACTORY]),LeadTimeGrid[STANDARD LEAD TIME])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for this! I actually ended up merging these two ables. Works the same.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      4 years ago

      you are welcome