Forum Discussion

ephramz's avatar
ephramz
Helper II
4 years ago
Solved

Combing table

I have two tables 1) Table 1 Column name: (Strategy), (Repair Scheme), (Engine Type), (Package), and otehr columns 2)Table 2: Column name: (Strategy), (FRS), (EngType), (Package Code), and oteh...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ephramz , Try a new column like this in table 2

     

    maxx(filter(Table2 , Table1[Strategy] = Table2[Strategy] && Table1[Engine Type] = Table2[EngType] && Table1[Package] = Table2[Package Code] ),Table2[T1Pack])

     

    add or remove joins in filter

amitchandak's avatar
amitchandak
Super User
4 years ago

ephramz , Try a new column like this in table 2

 

maxx(filter(Table2 , Table1[Strategy] = Table2[Strategy] && Table1[Engine Type] = Table2[EngType] && Table1[Package] = Table2[Package Code] ),Table2[T1Pack])

 

add or remove joins in filter