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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
210 | |
49 | |
45 | |
44 | |
42 |
User | Count |
---|---|
262 | |
211 | |
103 | |
79 | |
65 |