Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have the following issue:
I have the current price and I have to calculate the final and the future prices based on previous ones with this formula:
I've tried this:
Could you, please help?
@Otaki your reply doesn't help. What you have tried? What result you are getting? Can you provide more details, If you just say, it doesn't solve the issue, it is very hard to know what you have tried so far.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Sorry, @parry2k,
The issue is that we don't actually have a cumulative percentage on one and the same value. we have to take exactly the previous value then multiply it with the exact percentage of the period and subtract the different parameters. With productX I still couldn't get the exact results.
@Otaki check this video on my youtube channel, you need to use PRODUCTX function https://youtu.be/9Mj592bSKq0
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
unfortunately, productX doesn't solve the issue
@Otaki Perhaps:
Final price column =
VAR __Year = [Year]
VAR __PreviousYear = __Year - 1
VAR __PYFinalPrice = MAXX(FILTER('Facts',[Year]=__PreviousYear),[Final price])
RETURN
__PYFinalPrice + __PYFinalPrice * [Increase Percent] - [Decrease const]
This was actually my first idea however it doesn't work from the 3rd row on, as there are no values