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

У вашего броузера проблема в совместимости с HTML5

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 Text.Combine. Mike seeks a single-formula solution in Power Query but runs into a problem using “each” with two iterators.
Table of Contents
(0:00) Introduction of the problem
(0:37) Bill’s Power Query solution
(2:31) Concatenating text in Power Query with Text.Combine
(3:39) Mike’s Solution
(6:09) Mike explains “each” keyword
(6:55) Difficulty due to two iterators
(8:45) Mike uses an explicit variable
(4:30) Iterating over each row in Power Query
(11:19) Bill story about ModelOff game