From the course: Advanced Power Query

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Learning iterations by transforming multiple columns

Learning iterations by transforming multiple columns

From the course: Advanced Power Query

Start my 1-month free trial Buy for my team

Learning iterations by transforming multiple columns

“

- Let's take our learning to the next level by applying iterations to not just one column, but multiple columns. If that did not make sense, you have to take a look at the example and the practical application that I've got for you. No further ado. Let's start. Here I bring to you a very interesting case, which is where we have got a couple of columns and we would like the transformation to be applied on multiple columns. Take a look at what do I mean by this. So we've got Date, Product, Region. These are my text columns, and then there are a bunch of columns containing numbers. Notice that every single column is denoted by a million, which is an mn towards in the end, and for all of these columns which are denoted by a million in the end, I would like to convert the numbers into an actual million by taking the number and multiplying it with the 10 raised to the power of six. That's what I'd like to do, but for all of these columns, and I would want this process to be dynamic. That…

Contents