cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benjamin14 Frequent Visitor
Frequent Visitor

Data shapping - Multiple parameters in both rows and columns

Hi all,

 

I am seeking your help to solve a problem of data shapping. I really think it is basic but I could not find a solution by myself or online (key words are not obvious).

 

My data is in an Excel file. This Excel file is a query from an Essbase database.
The key point is that I cannot change the structure of this file. 

 

Here is the retrieve from Essbase imported in Power BI (limited to a few columns and rows for the topic 🙂 )

 

Exemple forum1.PNG

 

What I am trying to obtain is this :

Exemple forum2.PNG

A database with 1 data per row.

It is easy to achieve this with only 1 parameter in column (in the screenshot above, I removed my column "Diesel" and only kep the stations) : first I transpose the table and then I unpivot the columns.

 

But I don"t know how to do when starting with two parameters in column (the name of the station and the product, here Diesel)..

 

Any help would be really appreciated !!

Best regards,

 

Benjamin

6 REPLIES 6
Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data shapping - Multiple parameters in both rows and columns

Up !

Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data shapping - Multiple parameters in both rows and columns

Up 🙂

Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data shapping - Multiple parameters in both rows and columns

Up

Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data shapping - Multiple parameters in both rows and columns

Hi all,

 

I'm still looking for help regarding this topic. That would be great !  

 

Best regards,

 

Benjamin

Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data tttCX- Multiple parameters in both rows and columns

Up

Benjamin14 Frequent Visitor
Frequent Visitor

Re: Data shapping - Multiple parameters in both rows and columns

Hi,

 

I am still looking for help regarding this problem. Any clues please ?

 

BR

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 266 members 2,496 guests
Please welcome our newest community members: