table merging

[Tomek1982]

How to merge such two tables:

to get such a result (value is divided by shares and bonds percentage)?

pbix is here if needed.

[Ahmedx]

Hi pls try this code

let
    Source = #"funds structure",
    #"Replaced Value" = Table.ReplaceValue(Source,null,0,Replacer.ReplaceValue,{"shares", "bonds"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"funds"}, "Attribute", "Value"),
    #"Merged Queries" = Table.NestedJoin(#"Unpivoted Other Columns", {"funds"}, #"funds value", {"funds"}, "funds value", JoinKind.LeftOuter),
    #"Expanded funds value" = Table.ExpandTableColumn(#"Merged Queries", "funds value", {"value"}, {"value.1"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded funds value",{{"value.1", type number}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "NewValue", each [Value]*[value.1]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Value", "value.1"})
in
    #"Removed Columns"

[Ahmedx · Accepted solution]

pls try

https://1drv.ms/u/s!AiUZ0Ws7G26RixiNlqDYcajDe8kv?e=lDPDEH