Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello guys
thanks in advance for your help
I need the percentage of growth or decrease from one month to another, the problem appears when the stock of the previous month is 0, it does not calculate well, can you help me thanks
_PREV M 9l =
CALCULATE(SUM('STOCKS ES FERT'[9L]);
PREVIOUSMONTH('FiscalCalendar II'[Date]))
_STOCK 9L = SUMX('STOCKS ES FERT';
'STOCKS ES FERT'[9L])
_% PREV M 9l =
IF(SUM('STOCKS ES FERT'[9L])>0;
DIVIDE(SUMX('STOCKS ES FERT';[_STOCK 9L]);
CALCULATE(SUM('STOCKS ES FERT'[9L]);
PREVIOUSMONTH('FiscalCalendar II'[Date])))-1)
Solved! Go to Solution.
Try like
DIVIDE(([_STOCK 9L]-[_PREV M 9l]);[_PREV M 9l])
Previous Month is 0, so % increase is infinity 2/0
Hi
thanks for your help
your formula partially fixes the error, ok the erroneous percentage disappears,
but it should propose a growth percentage stock previous month 0 current stock 2 percentage increase + 200%, no ?
thanks
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |