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)
I tried using a calculated column but it sum the entire table I need it to sum only by deal#, and last year. I am using Power BI for a visualization.
I am new at DAX and I am having difficulties unterstanding the use of filters at the row level. How can I define a filter at the row level.
Thanks for your advise. But how would I do that in power query. I will try it.
I am trying to upload the report but I cannot do it. here is the link to the report how can I share it with you.
https://drive.google.com/file/d/1LoLGTkkvuoigte0iaq-1Y1RrnTXXESIn/view?usp=sharing
Here is the file.
Thanks for all your help.
Thank you!
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 | |
19 |