Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
viltxes14
Helper I
Helper I

Project values using CAGR in time intervals

Hi, 

 

I wonder if anybody can help with me this one. I´m trying to obtain a table of projected values using the last available value by country and multiplying it by a CAGR I have in another table by region with intervals of time. My tables look like this: 

 

Table 1: 

Country: USA, Spain, ...

Year: 2010, 2011,...

Value: 100, 200, ...

 

Table 2: 

Region: America, Europe, ...

CAGR: 2%, 1%, ...

CAGR start date: 01/01/2020, 01/01/2026,...

CAGR end date: 31/12/2025, 31/12/2030,...

 

The result I need is a table country and year that uses last value available from the other table and the CAGR in the intervals and projects a yearly value for the future and keeps the available for the past years. 

 

Seems quite tough for me! any hints?

thanks a lot!!!

1 REPLY 1
viltxes14
Helper I
Helper I

Nobody can help? thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors