Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Try like
DIVIDE(([_STOCK 9L]-[_PREV M 9l]);[_PREV M 9l])
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
Previous Month is 0, so % increase is infinity 2/0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |