Suggestion require to do data modeling .?

[ashmitp869]

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

[Anonymous]

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.

[Daniel29195 · Accepted solution]

@ashmitp869 

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! 🙏