cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisWei
Frequent Visitor

Add new Rows maually in Power Query Editor

Hi guys,

i need help with the Power Query Editor. Is it possible to add just 2-3 Rows in Table, which is already in your Data model?

 

tempsnip.png

2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

@ChrisWei create another table by adding new rows and then append with your existing table. Make sure the new table you create has the same column names

 

parry2k_0-1643991003419.png

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

serpiva64
Super User
Super User

Hi, 

You can use Table.Insert Rows

something like this :

= Table.InsertRows(#"Changed Type",5,{ [Statement Date = "1/5/2022", Currency = "EUR",Amount in Local Currency = "1"] })

where 5 is the number of the last row and what is between square brackets is the row (in this exemple trere are 3 columns Statement Date,Currency and Amount in Local Currency)

 

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

View solution in original post

2 REPLIES 2
serpiva64
Super User
Super User

Hi, 

You can use Table.Insert Rows

something like this :

= Table.InsertRows(#"Changed Type",5,{ [Statement Date = "1/5/2022", Currency = "EUR",Amount in Local Currency = "1"] })

where 5 is the number of the last row and what is between square brackets is the row (in this exemple trere are 3 columns Statement Date,Currency and Amount in Local Currency)

 

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

parry2k
Super User
Super User

@ChrisWei create another table by adding new rows and then append with your existing table. Make sure the new table you create has the same column names

 

parry2k_0-1643991003419.png

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors