Forum Discussion
Solved
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 Inflatio...
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
Super Usercool_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% |