Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |