Forum Discussion

azizdoghmi's avatar
azizdoghmi
Helper I
5 years ago
Solved

Problem with lookup

Hi,    I have 2 tables : TABLE PROJECT Project ID - Project Name-Project description 1-AA-kkkkkk 2-BB-oooooo 3-CC-iiiiiiiii   TABLE EVENT Event ID - Event name-Project ID 1-xxx-1 2-yyy-1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi azizdoghmi 

    You can link two tables by Project ID column (one to many) and set Project ID column to show items with no data.

    Or you can build a new table by merge function in Power Query Editor.

    Merge Project and Event Table by Project ID columns and join kind = left outer .

    Result is as below.

    You can download the pbix file from this link: Problem with lookup

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

amitchandak's avatar
amitchandak
Super User
5 years ago

azizdoghmi , Simply Create a join on project id.

Create a measure, add +0 on that