Forum Discussion
DAX Formula Error
Hi Experts
i am trying to replicate the Calculation in tabke below in Power BI. i.e. Cell H4*G5 and copy down in column H5 onwrds. Here is a link to a site that was given to me and i have followed example 5 (see link)
See example 5:
https://exceleratorbi.com.au/compound-growth-using-dax/
Attached is my PBIX file with sample data. please refer to Table STEMBRANDYEARS
My H Column is [Holder Column]
1-D/N is 1-e_i/d_i and i am trying to populate the result into column s(t) my measure is in this column.
not sure what i am doing wrong.
https://www.dropbox.com/s/auvmnu2so83rfiv/Test_KPV_1.1_%281%29.pbix?dl=0
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.