Forum Discussion
Data model issue
Hi i have 4 tables. 1. Budgets by product by month 2. Products 3. Date table 4. Sales i have created the relationships as below date to sales date to budgets budgets to product sales t...
Not sure if I am clear
calculate(divide(sum(Sales[Sales Amount]),sum('Budget'[Budget Value])))Then if you view data by product and month you should get desired values.