Forum Discussion
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])
Gracias
KV's
2 Replies
- parry2k
Super User
@Udt_KV Lee este post para obtener tu respuesta rápidamente.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490