Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
New to Power BI and have come across a dataset that I am exploring and have an issue that I don't know how to solve when it comes to modelling and building relationships.
I was hoping to get some help from the community.
I have this table with three columns that I have renamed to "Inventory_Lookup" (see pic) that I'm not able to connect correctly. I have listed my questions below.
- Is this a lookup/dimension table? Or is it actually a fact/data table?
- How do I connect it properly since there are no unique values in the table? Have I done it the right way as shown in the picture (both directions from sales table to product_lookup and one to many from product_lookup to Inventory_lookup)?
Thanks in advance.
Solved! Go to Solution.
Hi @Clay82 ,
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
Hi @Clay82 ,
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |