22 - Adding a row to a table in Power Query скачать в хорошем качестве

22 - Adding a row to a table in Power Query

You may need to add a row to your dataset to test if a condition/filter/etc. applies, but there's no examples in your current dataset. This video shows how to add a row, allowing you to test your condition without altering your original dataset. I show two methods to achieve this: 1) Creating a table and appending the two tables. This is easy, especially if you have many columns. You do need to do a lot of steps. 2) Directly add a row to your table, with a function. The syntax is a bit weird, and you do need to add a value for each column. The more columns you have, the more annoying the function is. 00:00 - Intro 01:25 - Add a new table + append 03:48 - Table.InsertRows