Forum Discussion
Solved
getting value from one table to another by matching two columns (data tables not directly related)
Hello -- I'm new to Power BI and i've been working at this forever now and can't seem to get it. I have to data tables, one is a list of M&A deals and one is a list of fees charged. These two tables ...
- To share upload pix or other file to file share site like drop box, one drive, etc. then share from that service and paste link here.
The file I listed connects data from two tables. You can have more than one bridge table. The measures don’t have to be numeric as in my examples. And if you need to lookup one value in the other table in prefer to perform a column calculation you can use RELATED or LOOKUPVALUE to get it
Seward12533
Solution Sage
Solution SageTo share upload pix or other file to file share site like drop box, one drive, etc. then share from that service and paste link here.
The file I listed connects data from two tables. You can have more than one bridge table. The measures don’t have to be numeric as in my examples. And if you need to lookup one value in the other table in prefer to perform a column calculation you can use RELATED or LOOKUPVALUE to get it
The file I listed connects data from two tables. You can have more than one bridge table. The measures don’t have to be numeric as in my examples. And if you need to lookup one value in the other table in prefer to perform a column calculation you can use RELATED or LOOKUPVALUE to get it
Thanks Seward12533. My issue is that i need to calculate by matching TWO columns. Here's the sample file. As noted above, starting with Table 1, i need to match the CIK and the Year to teh CIK and Year in Table 2, and retrieve the fees. The two tables are connected via a bridge lookup table.
Thanks in advance!!!