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
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to use SELECTCOLUMNS function.

Here is my test table:

Then i define a policy, if i want to show the value of 'A10003' and 'A10005', try this calculated table:

Table = DISTINCT(SELECTCOLUMNS(FILTER(Table1,Table1[CustomerID]="A10003"||Table1[CustomerID]="A10005"),"CustomerID",Table1[CustomerID],"Value",Table1[Value]))

The result shows:

Hope this helps.

 

Best Regards,

Giotto Zhi