Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |