In power query, I need to make multiple columns to build on an equation and I don't want 40 custom columns in my steps. How can I make my below equation run through one step (probably two for expanding columns) for 10+ columns? The columns called for a and b change FYI.
Power Query:
= Table.AddColumn(#"Replace From List", "Dup1 ScoreName1", each let
a = List.Distinct(Text.Split([#"Customer - Copy1"], " ")),
b = List.Distinct(Text.Split([#"NameLine1 - Copy1"], " "))
in try
List.Count(List.Intersect({a, b})) / List.Count(a) otherwise null)