Forum Discussion
Allocate Budget within FactSales/FactInvoice or create separate FactBudget Table?
Hey all, Some background: I am trying to figure out best practice for setting up my budget within my data model. Currently: My company uses multiple Consultants for different Projects for a...
TomMartens
Super User
Super UserHey,
personally I use both pattern, #1 and #2.
At the current moment i tend to use a relationship based approach as a budget sometimes exists on an aggregated level, this is one of use cases for many-to-many relationships.
Maybe this article fill provide additional insights: https://www.daxpatterns.com/budget-patterns/
Regards,
Tom