Power BI - Get value from a different table

Hi r_user ，

What is your data source? If it's an Excel workbook, you can filter out all the Project x tables in the Source step and append them as one table.

Create a new blank query --> paste the m-code of Source step --> Filter the Name column and expand columns and remove the unwanted columns --> result.

At this point, you can use the merge query to get the start date of each project.

If this is not the case, and each Project table has project information only in the table name, you will have to consider adding a custom column for the project name and then repeat the above steps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum