DAX Formula Error

Hi, It seems that you want to calculate running multiplication based on year, right? If so, you could try to use below expression to see whether it works or not

Column = exp(
     SUMX(
          FILTER(ALL(Table4), Table4[year]<=EARLIER(Table4[year])),
          ln(Table4[Column1])
         )
    
      )

Or

Measure 8 = exp(
     SUMX(
          FILTER(ALL(Table4), Table4[year]<=MAX(Table4[year])),
          ln(Table4[Column1])
         )
    
      )

You could refer to Cumulative Interest or Inflation, Multiplying Every Value in a Column, Why Don’t We Have PRODUCTX? for details

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.