Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |