Help with columns (maybe pivot?)

[hcmellinger]

Hello,

I'm hoping someone can help me. I have this table I'm trying to make where the deliverable type will vary based on a drop down select tool in our system integrated with power bi. On the right side the column labelled "Number of Deliverables" shows the total number of deliverables from all deliverable types (Email orientation, Gif, and Key Visual) but I'm trying to find a way where I can have just one column called number of deliverables which will return the individual number of deliverables for each deliverable type. Type A in our system is Email Orientation and has 4 deliverables, shown in its column, B is the Gif and has 8 deliverables, shown in its column, and Key Visual would have 1 which I removed as the picture was too large for the screenshot. I'm trying to find a way where I can only have one column next to the deliverable type column (like they do in pivot charts) which will just list out the # of deliverables so the table doesn't look so messy so hypothetically we could have just one column to the right of the Delivrable type column which will have a 4 next to email orientation, 8 next to Gif, and 1 next to Key Visual and the Total Number of deliverables (13) in the next column. Does anyone have any ideas? 

Please let me know, thank you!

[Anonymous]

Hi @hcmellinger ,

Can you provide some sample data?
Unpivot maybe helpful but it depends on your data model. I can't test without sample data, and I can't guess what your data model looks like based on your screenshots.

Best Regards,
Dino Tao

[hcmellinger]

Hi!

Yes, sorry, attaching pictures below.

So currently, our Data is looking like this because we added 3 calculation columns to show the number of deliverables for each deliverable type:

But what we want is to make it look more like this where everything can be consolidated into fewer columns:

Where we have all deliverables associated with the parent task listed out in one column next to the activity ID/deliverable Type (which is the parent task) and then the next column popoulates with the numbers for each of these deliverable types.

Please let me know if you need additional information.

Thank you!

[Anonymous]

Hi @hcmellinger ,

As you say, the results you have realized so far are derived from calculated columns. Pivot or Unpivot can only be done in Power Query, but neither the measures nor the calculated columns are visible in Power Query. 
That means you can't work with the three existing columns, only with the source dataset. This would require you to provide a sample of your source data, as well as a description of how these were calculated:

Best Regards,
Dino Tao