Forum Discussion

Alphasyrius's avatar
Alphasyrius
Frequent Visitor
6 years ago

Search for parent value

Hello All,   I have a table called "Project", the unique key is a project number on 6 digits, column name "ProjectNumber". Each project can be part of a larger project, so I have a column "ParentPr...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Alphasyrius ,

 

According to your description, are you trying  to  Lookupvalue from another table with multiple values? You can create a calculated column for search values from another table. Please refer to https://community.powerbi.com/t5/Desktop/Lookupvalue-from-another-table-with-multiple-values/td-p/678953

 

Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

 

Please do mask sensitive data before uploading.

 

Thanks for your understanding and support.

 

Best Regards,

Dedmon Dai