Forum Discussion
getting value from one table to another by matching two columns (data tables not directly related)
- 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
Solution SageWhile Generate has its uses, I see many people trying to force a EXCEL paradigm into Power BI and create actual tables to represent the data. The power of PowerBI is that it can do most of this work for you when building visuals, Its all about Filter Context - see this tutorial I put together and see if it helps.
https://1drv.ms/u/s!AuCIkLeqFmlhhJgzLZ6jPcWgLGu3Yw
Hello, I'm not sure I'm understanding the proposed approaches, and all my previous replies weren't posting properly. I'm trying to attach sample data, but it's not working. How do I do that? Essentially, i want to add columns to table one that would give the fees of the acquirer and target in year of transaction (column 1) and fees "year of transaction +1" (column 2). The only way to do this is to match the KEY and the YEAR between tables 1 and 2. But I don't know how to do this in Power BI. If it helps, i have lookup tables that each of the tables are connected to but the data tables are not connected directly.
- Seward12533To 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 itThanks 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!!!