Forum Discussion
Connecting two tables with allocation
Hi -
I am a new user of PBI. I have two tables, table #1 has connection with multiple items in table #2 which has time series values. Table #1 has % allocation for each line, which means for example line 1 in table #1 is linked to line #4 and line #7 in table #2 but needs to multiple all values of line #4 by 60% and line #7 by 35%.
I already have a column with this allocation value in table #1, but I am wondering how can I do this connection between the 2 tables with the allocation column in action?
Your guidance is highly appreciated.
Thank you,
AE
7 Replies
Hello aeldiasty
Is it possible to share the sample data structre for the tables and the expected output (do you need it as a measure or a column)?
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedInIt deosn't matter if it is column or measure. My data is something similar to the below, I undertand I will ahve to unpivot the Table #2, but I am stuck at replicating somethin like vlookup then multiply each of Sub-iitem value by the corresponding allocation in the connected Item.
Table 1
Table 2 Item Allocation Sub-Item Sub-Item 1/1/2021 2/1/2021 3/1/2021 4/1/2021 1 30% A A $100 $90 $120 $80 1 23% B B $230 $200 $190 $220 2 77% B 3 70% A Thank you,
AE
aeldiasty , share the final output. Mark contributes @
aeldiasty , Need sample data to say that.
