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

[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)

[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)

[judywang]

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.

[guppi]

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?

[MiteshYadav]

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

[milpatel]

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.

[calehoanhan]

? newstep1=Table.InsertRows(newstep, 0, {[Location=SUMX(FILTER(Location - beginner, Location - beginner[Name] = "East"), Location - beginner[Location])
, address='1.sum', Name=null
]})
how to add total row for Name[East] column? i thought so but it doesn't work!
help me