Forum Discussion

Katek10's avatar
Katek10
Frequent Visitor
6 years ago
Solved

Fill in data in a column for same duplicate value from other column

Dear PBI Community,       I have 2 tables related to each other by IP Address column (many-to-many). In one of them I want to reflect the "support group" data, which is only in the 2nd table. So I g...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    New column in table 1

    Support Group = minx(FILTER(Table2,Table2[Hostname]=Table1[Hostname] && Table1[IP Address]=Table2[IP Address]),Table2[Support Group])
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

New column in table 1

Support Group = minx(FILTER(Table2,Table2[Hostname]=Table1[Hostname] && Table1[IP Address]=Table2[IP Address]),Table2[Support Group])
Katek10's avatar
Katek10
Frequent Visitor
6 years ago

Many thanks indeed Amit!

 

        It works!!! I get the expected outcome, no blanks for duplicated IPs, support groups are duplicated as many times as IPs are. Really appreciate all your time spent on this and your support!

 

Cheers,

K