How to Add Rows To a Table in Power BI - Beginner and Non-Beginner Tutorial-Power BI Tips and Tricks

How do we add rows to a table? Can we insert rows to a table in Power BI?
Of course we can, adding or inserting rows to a table in Power BI is possible using Power Query Editor.
In this video, I am going to show you two ways we can insert custom rows in Power BI tables. Inserting your own custom rows allows you to adjust your dataset as per your need since, in data world, data is never perfect and we always have to do transformation and cleaning.
I hope you will like this video.
Thanks,
Rosh

[@rojibhattarai1595]

Thanks Rosh

[@unnikrishnansanthosh]

excellent, thank you for sharing

[@powerbitutorialforbeginners]

My pleasure! Thanks for watching

[@user-rm7op5hc9h]

Awesome tutorial

[@powerbitutorialforbeginners]

Thanks

[@alizz_in_wonderland]

Hi I just wonder what If I only want to add 1 value (for example the title) at the first column instead of gotta fill the whole row (given the table has many columns and I don't want to go put the rest column = 0)

[@anshumandass]

Thanks this is informative 😊😊
How do I Automatically add a calculated measure to a new row everyday along with date in separate column ( Date stamp)

[@khurrumsandhu]

your skill made me subscribe ....

[@powerbitutorialforbeginners]

Appreciate your comment. Thanks a lot.

[@judywang656]

Thank you for the video, I found it is very helpful! May I know how to put date format into the M code? For example, one column is date, and we need to add a row including a new date.

[@powerbitutorialforbeginners]

Hey Judy,
I think if you want use custom date use #date(2023,01,01) or #datetime(2023,01,01,12,00,00)
Format is #date(year,month,day) for date
#datetime(year, month, day, hour, minute, second) for DateTime
Do not use “” quotation

[@guppi1]

Great tips. But I wonder, what if the table have a lot of rows, say a thousand or two thousand rows, how can we make the location (row index) more dynamic? Is there M code that automatically know what is the last row so we can add + 1 to make a new row?

[@powerbitutorialforbeginners]

Hey there,
You can always use List.Count() m function to get the last index.
You can use Table.RowCount() as well
Ensure it is subtracted by 1 since index starts at 0.
Pick a function based on how much time they consume.

[@MiteshYadav]

Can we add calculated row in power bi using m or Dax ?..

[@powerbitutorialforbeginners]

Yes we can. Learning M code unlocks new ways we can manipulate and manage data in our report.
Not only rows, you can even create your own custom table based on calculations of other multiple tables. I highly recommend people to learn M query.

[@milpatel83]

Why would you want to manually code like this? Makes no sense. My suggestion, albeit more work but far more manageable would be add row in a csv file, import this data and append to the database table, that way the data is separate from the visuals and far easier to update and debug.