Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Transpose table view with data in multiple dataset.

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
 InventoryUnitsMeasure-1Measure-2Measure-3Measure-4Measure-5
Actual       
Scenario-1       
Scenario-2       

 

Thanks,

Prab.

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

       

      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.

       

       

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Anonymous 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

       

      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