DAX help

[cool_333]

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%

[ppm1 · Accepted solution]

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]

@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.

[cool_333]

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%