CAGR for Group

This is the power bi visual. The CAGR values are calculated in Acess SQL because this current table is a query table table from several other tables . 

This is the SQL in acess 

SELECT t1.pillar, t1.[Business Unit], t1.[Income type], t1.[Statement type], t1.Year AS yr_1, t2.Year AS yr_2, t1.value AS value_1, t2.value AS value_2, ((t1.value/t2.value)^(1/((IIf(t1.Year='2025 with Inorganic','2025',t1.Year))-(IIf(t2.Year='2025 with Inorganic','2025',t2.Year))))-1) AS cagr, IIf([t2].[Year]="2025 with Inorganic","Inorganic and Organic",
IIf([t2].[Year]="Net Organic Growth","Net Organic Growth","Organic")) AS [Growth Type]
FROM 20172025revenues AS t1 INNER JOIN 20172025revenues AS t2 ON (t1.pillar = t2.pillar) AND (t1.[Business Unit] = t2.[Business Unit]) AND (t1.[Income type] = t2.[Income type])
WHERE (((t1.[Business Unit])<>'Other And Consolidation Entries'));