March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
36 | |
27 | |
26 | |
20 | |
15 |