Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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% |
Solved! Go to 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
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
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% |
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |