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 everybody!
I'm in the process of calculating a YTD Inflation. For this, I have a table of Inflation with Country, Month, GrowthPercentage. The calculation for this is:
For the months of the selected period sum 1 to each growth, multiply all of them, and subtract 1 to the result.
Example: 0.03 >> 1.03
1.03*1.12*1.18*1.01 = 1.37
1.37 >> 0.37 >> 37%
How can I perform this? Because there is SUM and SUMX function, but here what I need is a MULT funcion or something to multiply. Any ideas?
Thanks in advance.
Solved! Go to Solution.
Hi @Anonymous
If I understand you correctly I think the PRODUCT fucntion may probably work. If you are happy with the essence of the function, it can be extended to work with your data.
Result = VAR IndexColumn = Table3[Index] RETURN CALCULATE( PRODUCT( 'Table3'[Rate] ), FILTER( 'Table3', 'Table3'[Index]<=IndexColumn ) )
Hi @Anonymous
If I understand you correctly I think the PRODUCT fucntion may probably work. If you are happy with the essence of the function, it can be extended to work with your data.
Result = VAR IndexColumn = Table3[Index] RETURN CALCULATE( PRODUCT( 'Table3'[Rate] ), FILTER( 'Table3', 'Table3'[Index]<=IndexColumn ) )
So many thanks @Phil_Seamark!
That was exactly what I been looking for. I perfectly performed what I needed.
Have a great day!
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |