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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.