Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I have two measures:
LineAmountMTD = TOTALMTD(Sum(Invoices[LineItem_LineAmount]),'Date'[Date], Invoices[Type]="AccRec")
PreviousMonthLineAmount = TOTALMTD(Sum(Invoices[LineItem_LineAmount]),PREVIOUSMONTH('Date'[Date]),Invoices[Type]="AccRec")
Now, I need to calculate percentage of growth this month vs last month. I am using this measure:
SalesAmountGrowthPercentage = DIVIDE([PreviousMonthLineAmount]-[LineAmountMTD], [LineAmountMTD])
This does not give me the right output. I might need to just grab the final cumulative totals from first two measures, I guess.
What am I doing wrong here?
Solved! Go to Solution.
Well, It seems to be giving the right answer. It was few filters that I had used that was messing things up.
Well, It seems to be giving the right answer. It was few filters that I had used that was messing things up.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 45 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |