Transpose table view with data in multiple dataset.

[prab]

Hi,

Mypbi has two dataset with columns and measures as below..

Product  Planning

ProductKey

BuildDate

Units Actual

Column Inventory

Cumulative Measure1 Actual

Cumulative Measure2 Actual

Cumulative Measure3 Actual

Cumulative Measure4 Actual

Cumulative Measure5 Actual

Product  Planning Scenario

ProductKey

BuildDate

Units Scenario-1

Units Scenario-2

Column Inventory

Cumulative Measure1 Scenario-1

Cumulative Measure2 Scenario-1

Cumulative Measure3 Scenario-1

Cumulative Measure4 Scenario-1

Cumulative Measure5 Scenario-1

Cumulative Measure1 Scenario-2

Cumulative Measure2 Scenario-2

Cumulative Measure3 Scenario-2

Cumulative Measure4 Scenario-2

Cumulative Measure5 Scenario-2

Both dataset has one to many relation with ProductKey dataset.

With the above data model, is possible to create below table view in powerbi? 

If yes can you please help me on how to create.

Build date
	Inventory	Units	Measure-1	Measure-2	Measure-3	Measure-4	Measure-5
Actual
Scenario-1
Scenario-2

Thanks,

Prab.

[parry2k]

@prab your above explanation is as confusing as the original post or maybe I'm not able to understand it. Good luck. I hope someone will be able to answer it.

[prab]

Thank you @parry2k for your time and effort! 

Adding some sample data to better explain my requirement.. 

Below are sample data in the two dataset.. 

Below is the table view in power bi that I need help to create with the above data.. 

FYI: The measures are created and need help only to create a view to compare the data.

Thanks in advance!

-Prab

[parry2k]

@prab First it is not clear from your sample table what is column and what is measure. Could you share the structure of the raw tables, and paste it here? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[prab]

Sorry for not being clear enogh.. sorry for assuming that names provided against the dataset are clear enough.. Let me try to be more clear.

There are three type/group of data Actual, Scenario-1 and Scenario2.

For each type/group, there are different metric/measure created for which I need to create a view to compare the metric of different type of product/data.

Here are details..

Columns of Product Planning Dataset
ProductKey
BuildDate
CM-Inventory
Units Actual

Measures of Product Planning Dataset

CTC
Cumulative Inventory
Cumulative POConsumed
Cumulative POValue
Cumulative Quantity

Columns of Product Planning Scenario dataset
ProductKey
BuildDate
CM-Inventory
Units Scenario-1
Units Scenario-2

Measures in  Product Planning Scenario dataset

CTC Scenario-1
Cumulative Inventory Scenario-1
Cumulative POConsumed Scenario-1
Cumulative POValue Scenario-1
Cumulative Quantity Scenario-1

CTC Scenario-2
Cumulative Inventory Scenario-2
Cumulative POConsumed Scenario-2
Cumulative POValue Scenario-2
Cumulative Quantity Scenario-2

Also there DimProduct dataset as Join table, this dataset is join both above datasets..

Column DimProduct dataset 

ProductKey 

Looking to present the above columns and measure in the below table view

 Let me know if you are looking for any additional information.

Thanks,

Prab.