Forum Discussion

ITbeginner's avatar
ITbeginner
Regular Visitor
3 years ago
Solved

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

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 !!

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.