Forum Discussion
DAX help
Hi I need help with dax , output should be as per last 2 columns Compund Inflation & Quaterly Inflation using dax, please help.
| Month | Quarter | Inflation | Compounded Inflation | Quarterly Inflation |
| 01/01/2016 | Q4 2015 | -0.005 | 99.50% | 0.00% |
| 01/02/2016 | Q4 2015 | 0.002 | 99.70% | |
| 01/03/2016 | Q4 2015 | 0.003 | 100.00% | |
| 01/04/2016 | Q1 2016 | 0.002 | 100.20% | 0.60% |
| 01/05/2016 | Q1 2016 | 0.002 | 100.40% | |
| 01/06/2016 | Q1 2016 | 0.002 | 100.60% | |
| 01/07/2016 | Q2 2016 | -0.001 | 100.50% | 0.50% |
| 01/08/2016 | Q2 2016 | 0.003 | 100.80% | |
| 01/09/2016 | Q2 2016 | 0.003 | 101.10% | |
| 01/10/2016 | Q3 2016 | 0.001 | 101.20% | 0.70% |
| 01/11/2016 | Q3 2016 | 0.002 | 101.41% | |
| 01/12/2016 | Q3 2016 | 0.0039 | 101.80% |
Please try these measure expressions. Format them as a percentage. Replace T2 with your actual table name.
Compound = VAR maxdate = MAX ( T2[Month] ) RETURN 1 + CALCULATE ( SUM ( T2[Inflation] ), ALL ( T2 ), T2[Month] <= maxdate ) Compound Quarter = VAR maxdate = MAX ( T2[Month] ) RETURN 1 + CALCULATE ( SUM ( T2[Inflation] ), ALL ( T2 ), VALUES ( T2[Quarter] ), T2[Month] <= maxdate )Pat
3 Replies
ppm1Solution Sage
Please try these measure expressions. Format them as a percentage. Replace T2 with your actual table name.
Compound = VAR maxdate = MAX ( T2[Month] ) RETURN 1 + CALCULATE ( SUM ( T2[Inflation] ), ALL ( T2 ), T2[Month] <= maxdate ) Compound Quarter = VAR maxdate = MAX ( T2[Month] ) RETURN 1 + CALCULATE ( SUM ( T2[Inflation] ), ALL ( T2 ), VALUES ( T2[Quarter] ), T2[Month] <= maxdate )Pat
- amitchandak
Super User
cool_333 ,
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Ok so I need dax formulas to acheive Compounded infation and quaterly inflation , right now it is calculated in excel. So what is the dax formula to acheive 99.50%, 99.70%, 100.00%,100.20% and Quaterly inflation percentage 0.00%, 0.60% and so on? The data we get is the dates, quaters and inflation and we shpould be able to calculate compound inflation and quaterly inflation using dax.
Month Quarter Inflation Compounded Inflation Quarterly Inflation 01/01/2016 Q4 2015 -0.005 99.50% 0.00% 01/02/2016 Q4 2015 0.002 99.70% 01/03/2016 Q4 2015 0.003 100.00% 01/04/2016 Q1 2016 0.002 100.20% 0.60%
