Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
12 | |
11 | |
10 |