Forum Discussion
Allocation by Branches
Hi All, i have a branch table and the columns are; Country, City, Branch Also i have a expense table and the columns are; Date, Branch, Expense type, Amount Also i have a sales table and the col...
Hey emre34 ,
this article explains how a value can be allocated to a different granularity: https://www.daxpatterns.com/budget/
If this does not help, create a pbix file that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the file to OneDrive, Google Drive, or Dropbox and share the link). If you are using a spreadsheet to create the sample data instead of the manual input method share the spreadsheet as well.
Do not forget to describe the expected output based on the sample data you provide.
Regards,
Tom