Excel power query examples how to#
Table.Join (Table1,Name,Table2,Name) The syntax would be Table.Join (. Learn how to use Power Query, which is a data automation tool that allows us to import, transform, and cleanse data in Excel or Power BI. Once the Formula Bar is visible, you simply click the fx icon to insert a new step and write the following formula. Now you have 2 queries there: One that imports the external data and another one that shows the result of the last import with the additional columns. If the Formula Bar is not visible in your Query Editor, you can turn it on via the View tab as shown in a picture. Rename this table to "SourceReturn" and load it to Power Query. The idea is based on the self-referencing-tables I've described here: How to create a Load History or Load Log in Power Query or Power BI – The BIccountantīut I've modified it a bit to make it easier - you can find an example in the file here: ġ) Create your import-query and load it to the worksheetĢ) Add your column an fill in the comments.
This is indeed a very useful functionality - I'm using it quite often (not only for comments, but also for collecting budget data in tables that also show actuals, previous plans and so on).
0 kommentar(er)
