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 |
---|---|
106 | |
88 | |
69 | |
52 | |
49 |
User | Count |
---|---|
156 | |
96 | |
80 | |
70 | |
70 |