Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have an issue regarding data modeling. I the issue with 4 tables relationships, 2 dimensions and 1 for facts.
My issue is that we have upgraded our budget table with new categories and the account type for each of these categories. That ruined our previous calculations and for budget vs sales comparison, namely because the brands can't be mapped without creating an extra column and messing up the other relationships. As you can see in the picture, the account table relates to the campaigns table and to the budget, the same for the region. But if I want brands creating a column that might not be filled in the budget table will ruin the relationships.
My questions are:
I know this subject is hard to explain, please let me know if you need further clarification.
Thanks,
Jorge
FYI @thschr
hi, @Jmenas
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
If you could refer to create the data model as below:
Best Regards,
Lin
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |