Compare 3 columns with Names in different Table and get required result

balajideshpande I hope this helps you! Thank You!!

>Merge query with Fuzzylookup.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8k3My83PSMxTCM7MS89Q0lEyNVCK1YlWCkrMykssyVBwSs1LKUoFihuZgsV9gYpzcxNTFByTUkpzgOLGQPWxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"First Name Last Name" = _t, Sales = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"First Name Last Name", type text}, {"Sales", Int64.Type}}),
    #"Merged Queries" = Table.FuzzyNestedJoin(#"Changed Type", {"First Name Last Name"}, #"Table B", {"Lastname Firstname"}, "Table B", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true]),
    #"Expanded Table B" = Table.ExpandTableColumn(#"Merged Queries", "Table B", {"Spent"}, {"Table B.Spent"}),
    #"Merged Queries1" = Table.FuzzyNestedJoin(#"Expanded Table B", {"First Name Last Name"}, #"Table C", {"Firstname"}, "Table C", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=0.5]),
    #"Expanded Table C" = Table.ExpandTableColumn(#"Merged Queries1", "Table C", {"Target"}, {"Table C.Target"})
in
    #"Expanded Table C"