Add/Insert/create a calculated row based on parent column

Hi ITbeginner ,

As far as I know, Power BI is calculated based on columns, so Power BI support us to add calculated columns by dax or custom columns by M code. Your requirement calculated row is not supported in Power BI.

Here I suggest you to load a new table with all rows you need to add into your data table which should have same column headers as your data table. Then append two tables in Power Query Editor.

For reference:

Append queries - Power Query | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.