课程: Advanced Power Query

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Examine Power Query UI limitations: Examples

Examine Power Query UI limitations: Examples

课程: Advanced Power Query

开始一个月试用 购买团队方案

Examine Power Query UI limitations: Examples

“

- I'm assuming that you're already pretty impressed with the user interface of Power Query and you're able to solve quite a lot of problems using the user interface only, but let me show you a few cases where the user interface is absolutely going to break. Are you ready? Consider the first example where the UI of the Power Query is going to fail us. We have got three CSVs here, Jan CSV, Feb CSV, and March CSV. And if you take a look at the data for every single CSV, it is the same across all the files. So for the month of Jan, we have the same columns, date, product, sales, and region, and they happen to be the same columns in the month of Feb and the same columns in the month of March. Now the task is to combine the data from all of these CSVs and bring it into a single Excel file. Let's just start from a blank Excel workbook, and I'm pretty sure that you already know of all the steps that I'm going to do using UI. So I'm going to be slightly quick right here. So I'm going to go…

内容