Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Help with columns (maybe pivot?)

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 ri...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

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