Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good afternoon,
I need to do a growth rate. I have seen many tutorials and I have not found the form. I have tried to do the following with negative results (based on an answer that was published in these forums):
Hi Mauro, It may be easier to split up all your different variables into metrics
Example.. have a meassure which will sum up all your VentasConDescuento Calculate(sum(Ventas)),"AddTheFilterHere..example" Descuento="Yes"))
Then do the same for the ones with no discount.
Finally do a Sum All meassure = calculate(sum(ventas),All(Ventas TABLE))
Then add a final meassure with the 3 above meassures [Ventas Con Descuento]-[Ventas] / [Ventas Totales]
Gracias Joorge_C
Lo que realmente quiero es una tasa de crecimiento de mes a mes o de año a año. Tengo que tener en cuenta la métrica de las ventas totales, lo que no sé cómo hacerlo es la suma del mes anterior o del año anterior para poder llegar a la fórmula:
(acto de venta - venta de hormigas) / venta y
gracias
User | Count |
---|---|
128 | |
112 | |
99 | |
65 | |
62 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |