Building a measure that calculates exponential value of last historical value

[Anonymous]

Hi, PBI community. I wanted to create a function that increases exponentially till the table's last value.

I attempted to simulate sample data below with a 2% increase over the last value of the historical data.

FY Quarters	Hisotrical Value	exponential forecast (last value * (1+0.02)^n)
Q2-2022	816101
Q3-2022	1441713
Q4-2022	479741	479741
Q1-2023		489336
Q2-2023		499123
Q3-2023		509105
Q4-2023		519287

Could someone possibly assist me in creating a measure that will allow me to achieve this? I have a date table with future and previous dates, where the Quarter column is derived from . I'd like to present it on a quarterly basis, and the math is getting complicated since I cant find the differerence of the date with Quarter column as it is a string value.

[parry2k · Accepted solution]

@Anonymous check this video on my youtube channel and tweak it as you see fit https://youtu.be/9Mj592bSKq0

✨ Follow us on LinkedIn and  to our YouTube channel

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

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.

[Anonymous]

Hello, Sir.

Thank you very much for your assistance. It appears that the logic is correct. However, one difficulty I'm having with my code is that I'm not getting the date of the last quarter's value.

For example, I obtain the following result since the end of the month of the last value is 2/2/2022, and the end of the month of the last value is obviously less than the end of the quarter of the last value.

I though this might work but not really:

var visible_lastdate = 
    CALCULATE(
        MAX('Future dates'[Date]),LASTNONBLANK('Future dates'[Date],[Historical Value]),
        ALL('Future dates'))

What I need now is to find the end date of the quarter of the last value, which in my case is 31/03/2022. Could you please assist me with this?