Calcular porcentaje de caída en las ventas

[GuilleLus]

Hola comunidad,

Quiero calcular el porcentaje de caída en las ventas. 

La medida tiene que ser creada entre la columna "caída en las ventas" (medida calculada) y "CobCuo1".

Podrían facilitarme algún ejemplo de cómo proceder en este caso?

Gracias! 

 

[Anonymous]

Hi @GuilleLus ,

Please state your question in English. According to my guess you are trying to calculate the percentage difference in sales, I have made simple samples and you can check the results as below:

% = var _t = ADDCOLUMNS('Table',"A",MAXX(FILTER(ALL('Table'),[ID]=EARLIER([ID])-1),[Value]))
RETURN DIVIDE(MAX('Table'[Value])-MAXX(_t,[A]),MAXX(_t,[A]))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[GuilleLus · Accepted solution]

Team_ Scott Chang,

Thaks for your cooperation. 

 Unfortunately I have not been able to resolve my query with your help.

I needs represent "Caida Cartera" in percentage, but has been impossible at the moment.

I send an image with more details.

Thank you again for your cooperation. 

[Anonymous]

Hi @GuilleLus ,

To be honest, I still don't quite understand what you mean. To calculate as a percentage, using the divide function seems to solve the problem. Can you show me what you expect?

Best regards,
Community Support Team_ Scott Chang

[GuilleLus]

Hi, Team_ Scott Chang

Thank you for your cooperation. Fortunately I was able to solve the problem.

Best regards, Guillermo.-