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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

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.

4 REPLIES 4
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

 

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

image.png

 

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

 

image.png

 

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

 

Thanks in advance!

-Prab

 

parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

 

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 

image.png

 

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

image.png

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

Thanks,

Prab.

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.