Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a DAX formula as follows
I have 4 columns Deal#, Unit, Year, Proposed Budget. I want to allocate revenue based on the % increase between last year total proposed budget and this year propose budget.
Say
2017 Proposed Budget was $115,000 and
2018 Proposed Budget was $125,000
% increase is 8.70%
(125000-115000)/115000
Now, for 2018 I have to allocate revenue as follows
(1 + 0.0870) * 2018 Proposed Budget
1.0870 * Each unit proposed budget
I tried this but it did not work. I have many deals
Created four measures
1)
TotalProposedBudget = SUM(Contract[ProposedBudget])
2)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |