Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Two fields of project table, ProjectIntitator and ProjectManager has values of WorkerId from WorkerTable.
I need to display names of ProjectInitiator and ProjectManager, but the name field from Worker table will always display only one value...
I created a new table as WorkerTableMgr(WorkerTable) and pointed ProjectManager of project table to WorkerId in new table.
But I am trying to figure out if we can have any other way to achieve this instead of duplicating the whole table..
Solved! Go to Solution.
Hi @BrianSK,
Based on my assumption, I created two sample tables like below:
ProjectTable WorkerTable
You want to display corresponding name from WorkerTable in ProjectTable, right? If so, please create calculated columns in ProjectTable as below:
Name of Intitator = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project Table'[ProjectIntitator]) Name of Manager = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project Table'[ProjectManager])
Best regards,
Yuliana Gu
Hi @BrianSK,
Based on my assumption, I created two sample tables like below:
ProjectTable WorkerTable
You want to display corresponding name from WorkerTable in ProjectTable, right? If so, please create calculated columns in ProjectTable as below:
Name of Intitator = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project Table'[ProjectIntitator]) Name of Manager = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project Table'[ProjectManager])
Best regards,
Yuliana Gu
Thanks a lot Yuliana !
Here's one approach to get you thinking ... https://powerpivotpro0-my.sharepoint.com/personal/austin_powerpivotpro_com/_layouts/15/guestaccess.a...
The relationship between projects and workers is complex, it's many to many.
Hi,
Share a sample dataset and show the expected result.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |