Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Lookup column from another table

Hi,    I want to create a new table in Power BI Desktop that has a column which lookups and returns each value from another column to use as an ID.    For example, Table 1 has column A called "Cu...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

You can always create a column in another table by using x functions and filters, even if there is no relation. or using lookup. Just make sure conditions are met. like

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])


new Column =
LOOKUPVALUE('Table'[Lot No.], 'Table'[Entry Type], "Output", 'Table'[Document No.], firstnonbank('Table'[Document No.],true()))
OR
new Column =
minx(filter('Table', 'Table'[Entry Type]= "Output" && 'Table'[Document No.]= earlier('Table'[Document No.])),'Table'[Lot No.])