Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Tasa crecimiento

 

Captura1.PNGCaptura2.PNGCaptura3.PNG

 

 

 

 

 

 

 

 

 

 

 

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):

2 REPLIES 2
Joorge_C
Resolver II
Resolver II

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]

 

 

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.