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

[ITbeginner]

Hey everyone,

I'm kinda new to Power BI and I would like some help with my issue.

Please refer to the screenshot below : I have a table "Planning" with a lot of columns, Project, Owner and 1 column for every week of type percentage.

I have multiple rows per user(owner) with each project and the time/percentage users plan to work on per week. I'm using the Total row to see how much time/percentage users will work per week.

But I would like to create/insert a calculated row named "Availability" that will calculate for each week the remaining percentage to reach 100% of their week time as you can see below. Something like insert row->calculate->100 - Sum(parent column)) but I don't know how to do it :'(  .With this the Total will automatically update to 100% too. Could you please give me advices on how to do this. I have a lot of columns so if I can do this based on parent column it would be perfect !

Thanks a lot !!

[Anonymous · Accepted solution]

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.

[amitchandak]

@ITbeginner , I usually use the extended dimension method for that

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU