cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

SUMA STOCK MENSUALES - SUMA DE MEDIDAS ACUMULADAS

Yo tengo el siguiente problema, necesito tener el stock mensual de cada tienda y despues sumar los stock de cada mes.

Tabla Movimientos:

201907;Tienda1;salida;-1

201906;Tienda2;Salida;-5

Hice una medida usando la tabla calendario:

Stock Mensual =
FILTER(ALL(Calendario);Calendario[Fecha]<=MAX(Calendario[Fecha])))

Y que tengo es este cuadro (considerar que para la tienda 1 en Agosto no hay movimiento)

Tienda;Periodo;Stock Mensual
Tienda1;201906;15
Tienda1;201907;14
Tienda1;201908;14

Tienda2;201906;10
Tienda2;201907;20
Tienda2;201908;30

¿Como puedo sumar todos los stocks? Es decir: Tienda = 43 y Tienda 2 = 60

4 REPLIES 4
Community Support

hi, @rodvaldes

If you still have the problem, please share a simple sample pbix file, It would help tremendously.

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion

Hi, try with this measure:

`Medida = SUMX(VALUES(Calendario[Periodo]),[StockMensual])`

Regards

Victor

Lima - Peru
New Member

El problema que tengo que el Stock Mensual no es un campo en la tabla, sino que es una medida. Lo probe y no me funciono.

Community Champion

I test it with your sample table and using the measure that you put it.

And add the last measure using Stock Mensual Mesaure.

Regards

Victor

Lima - Peru

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.