Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
28 | |
23 | |
22 | |
22 |