Forum Discussion
Lookup value from another table
Hello All,
I have a table called as Project ID master.
And i have another two tables as Contribution, and Billed Utilization.
these both tables having Project ID as a column.
I have created relation with these tables pro id column to Project ID master.
Now when i try to show values in a table,
i have choosed project id from Project Id master table, and Contribution column from Contribution table.
But when i try to choose Billed Utilization column from Billed Utilization table, then i cant, here i am getting error as
In below table added only Project ID(from Project ID master table,) and Contribution(From Contribution table)
When i try to add another column from Bileld Utilization in this table i got the below error
So how can i get the Contribution values and Bileld Utilization values from those respective tables into
Prject ID Master table
Any suggestions to write a dax function for this,
Mohan V
1 Reply
- MattAllingtonCommunity Champion
It should work. Go back and check
- is there a 1 to many relationship from ID master to both of he other tables?
- Have you put the correct Project ID column in your visual (from project ID master)?