Forum Discussion
Suggestion require to do data modeling .?
Hi there,
If any help from community
My Fact table has Budget Qty against ID in Fact table. The Budget Cost Codes have different Cost Value and there can be more than Budget Cost Codes with one ID. Thus I am unable to build any relationhip between them as it is (many to many)
What data modeling can be done in this scenario.
Thanks
you can create a bridge table between the two tables.
check this article for further clarification :
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
https://www.youtube.com/watch?v=D_5vxY0DDg0
hope this helps
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏
2 Replies
you can create a bridge table between the two tables.
check this article for further clarification :
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
https://www.youtube.com/watch?v=D_5vxY0DDg0
hope this helps
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏Hi ashmitp869 ,
Did you get your problem solved, if so, mark the correct answer as a marker, if not, provide more detailed information and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
