Combine and sum rows into one row

[BonusCup]

Hello,

New to Power BI.  I've tried watching videos and looking on line but can't seem to find a solution for what seems like an easy issue.  I have the current data with just 9 rows and would like to transform it into 4 rows.

Current:

Status	Value
draft	136
0_out_of_2_approvals	7
0_out_of_3_approvals	0
1_out_of_2_approvals	40
1_out_of_3_approvals	0
2_out_of_3_approvals	0
fully_approved	2
sent_for_sign	103
fully_executed	113

Desired:

Status	Value
draft	136
prep_and_review	49
sent_for_sign	103
fully_executed	113

TIA for any help

[DataNinja777]

Hi @BonusCup ,

You can produce your required output in many different ways using Power BI, and one of them is as follows:

Write a calculated column to identify the rows which contain "approv".

Status 2 = if(containsstring([Status],"approv")=True,"prep_and_review",'Table'[Status])

Then summarize the table using the dax calculated table function.  

I have attached an example pbix file.  

Best regards,

[Syk · Accepted solution]

In your Power Query Editor, lets make a new column to get the approvals into a singular status.

Under Add Column > Conditional Column and create some logic like...

Then you can delete your old status column and your data should look like this

Go back to the home tab and click Group By (you can also right click the new status column and group by there as well)

and voila 

[BonusCup]

@Syk Thanks so much for the detailed explanation.  I'm very experienced with Alteryx but starting to learn Power BI for reporting.  Excited to go to the Power Platform conference in Sept.  Thanks again!