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.
best regards, I would be very grateful if someone could help me with this case, I have the tables to relate, a representation of sales by the seller and the other budgets, the table of budgets has the figures divided by the type of product. When I am going to establish the relationship does not allow it to me because one of the tables does not have unique values, this is correct since each data is different in both sales and presupases. How can I establish this relationship considering that I am working in DirectQuery mode and not in Import mode? Thank you so much.
In your scenario, it seems you have Sales and Budgets tables which are fact tables. You should have other dimension tables like DimSeller, DimProduct, etc, and build the relationships to those fact tables based on the key column with unique values in dimension tables. It can became a snowflake/star schema. You can refer to AdventureWorksDW sample database.
Regards,
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 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |