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.
Estimados,
tengo una columnas de año 2017,meses de enero a diciembre, otra columna de ventas, quiero una columna adicional de crecimiento en porcentaje que compare las ventas de febrero con enero, marzo con febrero, abril con marzo asi...hasta diciembre con noviembre.
muchas gracias
Ricardo
Solved! Go to Solution.
Hi @Ricardo1,
I have columns for the year 2017, months for January to December, another column for sales, I want an additional column of growth in percentage that compares the sales from February to January, March to February, April to March as well ... to December to November .
Firstly add an index column in Query Editor mode.
In Data view mode, add a calculated column with below formula.
percentage = VAR previousmonthsales = CALCULATE ( SUM ( 'Monthly Sales'[Sales] ), FILTER ( ALLEXCEPT ( 'Monthly Sales', 'Monthly Sales'[Year] ), 'Monthly Sales'[Index] = EARLIER ( 'Monthly Sales'[Index] ) - 1 ) ) RETURN ( 'Monthly Sales'[Sales] - previousmonthsales ) / previousmonthsales
Best regards,
Yuliana Gu
Sres,
tengo una tabla columna meses( de enero a diciembre), columna ventas con importes en dolares.
necesito una columna calculando la tasa de crecimiento en porcentaje calculando de esta manera.
febrero con enero, marzo con febrero, abril con marzo, mayo con abril,...hasta diciembre con noviembre.
espero puedan ayudarme para hacer grafico en power bi.
Gracias
Meses | ventas | Tasa de crecimiento |
enero | $ 3.9M | |
febrero | $ 3.8M | -4.1% |
marzo | $ 4.4M | 17.5% |
abril | $ 5.1M | 14.2% |
mayo | $ 5.0M | -1.9% |
junio | $ 4.4M | -10.9% |
julio | $ 4.9M | 9.7% |
agosto | $ 4.8M | -1.3% |
septiembre | $ 4.4M | -8.4% |
octubre | $ 5.2M | 17.7% |
noviembre | $ 6.0M | 15.0% |
diciembre | $ 4.6M | -22.3% |
Hi @Ricardo1,
I have columns for the year 2017, months for January to December, another column for sales, I want an additional column of growth in percentage that compares the sales from February to January, March to February, April to March as well ... to December to November .
Firstly add an index column in Query Editor mode.
In Data view mode, add a calculated column with below formula.
percentage = VAR previousmonthsales = CALCULATE ( SUM ( 'Monthly Sales'[Sales] ), FILTER ( ALLEXCEPT ( 'Monthly Sales', 'Monthly Sales'[Year] ), 'Monthly Sales'[Index] = EARLIER ( 'Monthly Sales'[Index] ) - 1 ) ) RETURN ( 'Monthly Sales'[Sales] - previousmonthsales ) / previousmonthsales
Best regards,
Yuliana Gu
Good day Yuliana. I need exactly the same, try to Do and show me a message (Inifinito) and not the percentage. Could you help me ?. Thank you
Good day, I have the same problem. We appreciate help
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |