topic Re: DAX help in DAX Commands and Tips

DAX help

cool_333 — Fri, 27 Jan 2023 16:50:52 GMT

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%

Re: DAX help

amitchandak — Sat, 28 Jan 2023 02:51:50 GMT

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.

Re: DAX help

cool_333 — Sat, 28 Jan 2023 13:08:27 GMT

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%

Re: DAX help

ppm1 — Sat, 28 Jan 2023 16:05:45 GMT

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