Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Acciones de UID

Hola equipo,

Necesito el resultado de la columna "Stock restante" basado en la suma de UID (Uinque) para "[UID in Stock] -[Prod_Total]".
Por ejemplo: UID 30.A9KJ [UID in Stock]-[Prod_Total] y el resultado muestra todas las filas UID 30.A9KJ

Las fórmulas son,

1)

UiD Stock á DIVIDE(_x,_y)

_x
Var sum_unrest á CALCULATE(SUM('UID_Stock'[Unrest.stock of UID]),FILTER('UID_Stock','UID_Stock'[Tipo] á "Stock"))
var sum_qty á CALCULATE(SUM('UID_Stock'[Qual.insp.stock de UID]),FILTER('UID_Stock','UID_Stock'[Tipo] á "Stock"))
var avg_unrest ? CALCULATE(AVERAGE('UID_Stock'[Unrest.stock of UID]),FILTER('UID_Stock','UID_Stock'[Type] á "Production"))
var avg_qty ? CALCULATE(AVERAGE('UID_Stock'[Qual.insp.stock of UID]),FILTER('UID_Stock','UID_Stock'[Type] á "Production"))

devolución
average_qualityinspection + average_unrestricted + sum_unrestricted + sum_qualityinspection

_y : CALCULATE(AVERAGE('UID_Stock'[UID Qty)]),FILTER('UID_Stock','UID_Stock'[Check] á "In"))

2)

UID en Ptr. abierto ?
var UID_ops_po [Open POs]
var bom_qty [_y]
devolución
DIVIDE(Open POs,_y)
*****

Open POs ?
var sum_oppo á CALCULATE(SUM('UID_Stock'[UID Open POs]),FILTER('UID_Stock','UID_Stock'[Tipo] á "Stock"))
var avg_openpo á CALCULATE(AVERAGE('UID_Stock'[UID Open POs]),FILTER('UID_Stock','UID_Stock'[Type] á "Production"))
devolución
IF(NOT(ISFILTERED('Category per UID'[Category-Code])),(sum_oppo+avg_openpo))


_y : CALCULATE(AVERAGE('UID_Stock'[UID Qty)]),FILTER('UID_Stock','UID_Stock'[Check] á "In"))

3)

Prod_Total de cálculo (
VAR MaxDate á MAX ( 'Fecha de la factura'[Fecha] )
devolución
CALCULAR (
[_j],
'Fecha de la factura'[Fecha] <-MaxDate,
TODO ('Fecha de factura')
)
)

****
_j á SUM('UID_Stock'[Open Qty in Var])

screen.PNG

Gracias

KV's