Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
@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.
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
@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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |