Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
BrendonHerbert
Regular Visitor

Remodel Sharepoint data

Hi

 

I have a Sharepoint list containing weekly status updates for a project with multiple releases which in turn have multiple streams.

 

The form in Sharepoint is just one big form asking for information about each RAG item (Scope, Deliverables, Budget etc).

 

For each RAG there are the following

 

- RAG Indicator

- RAG Concern

- RAG Action

- RAG Due Date

 

A mocked up sample of the data that comes through to Power BI follows:

 

Annotation 2019-11-08 070814.png

 

I would like to split the RAG data into a separate table so I can summarise in a report (like table 2) when a Release/Week/Stream selection is made but cannot figure out how to do this in the query editor.

 

If anyone can provide any tips on how I might achieve this it would be greatly appreciated.

 

thanks in advance

 

Brendon

 
 
1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @BrendonHerbert 

Select "Scope RAG" column till the end "Deliverable Due" column, select "unpovot columns",

Then split "Attribute" column by delimiter space,

Select "Attribute.1" column and pivot column

Capture7.JPG

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @BrendonHerbert 

Select "Scope RAG" column till the end "Deliverable Due" column, select "unpovot columns",

Then split "Attribute" column by delimiter space,

Select "Attribute.1" column and pivot column

Capture7.JPG

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Maggie!! That worked perfectly.

Thank you very much

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.