The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
3-zzz-3
I need to have a new table with all the projects and related events (even if no event)
Project ID-Event ID- Project Name
1-1-xxx
1-2-yyy
2-
3-3-zzz
I have tried to link the table (relation one to many) bu twe cannot see the projects without event.
And LOOK up formula in DAX gives the message "A table of multiple values was supplied where a single value was expected"
thank you very much for your support
Solved! Go to Solution.
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.
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.
sorry I don't understand.
which formula in the measure?
how to join?
thks
@azizdoghmi , Simply Create a join on project id.
Create a measure, add +0 on that
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |