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
Hello 😃
I need to create a cost breakdown where the price reduces yearly for 4 years, each year 50% of the previous year.
Ex:
The benefit1 of 100$ starts in 2018
- Cost in 2018 is 50$
- Cost in 2019 is 25$
- Cost in 2020 is 12,5$
- Cost in 2021 is 6,25$
- Cost in 2022 is 0 (because the benefit only last 4 years)
Then I need to know the sum of all benefits in each year
The data I have is the total benefit (100$ in the example) and the date on which the benefit will start counting.
Solved! Go to Solution.
Hi @bibiubiali ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
Hi @bibiubiali ,
Can you explain in details and tell me what's your expected output?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
Hello,
I need the SUM per year of all benefits to be automatized according to new data entry (considering also the future gains in the 4 years period.
Ex.
With this data entry:
I need the 50% breakdown yearly to be calculated (for 4 years since the beginning of the benefit), like in this example:
So I can have the SUM of total benefits in $ that I will have yearly
(Remembering the only data in the file is the befit and the data it started or should start)
I was able to calculate it using:
Thanks =D
hello not really sure but mind if you try this?
2019 =
var curryear = 'Project savings'[Saving]/2
var preyear = calculate( 'Project savings'[Saving]/2),previousyear(date))
return
curryear + preyear
if no then i think you should use the new offset function
Hello @Anonymous
This way works the same as the solution I found, it won't automatically calculate all the new entries for upcoming years unless I create a new column, which is not ideal for me.
I will check about offset, thanks a lot!
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 |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
43 | |
31 | |
24 | |
23 | |
22 |