Power Query To Add Numbers To CSV Data - Dueling Excel 193

Another episode of the Dueling Excel podcast. This time, we tackle Siva’s problem of how to add 500 to a cell that contains many numbers: 123,234,345,456. Last week, in Duel 192, Bill used VBA and Mike used LET. Today, we both use Power Query, but in completely different ways. Bill seeks out the Power Query equivalent of the DAX CONCATENATEX function and finds a formula bar hack with . Mike seeks a single-formula solution in Power Query but runs into a problem using “each“ with two iterators.