Forum Discussion

2 Replies

  • 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"