Forum Discussion

Felizzpe's avatar
Felizzpe
New Member
1 year ago
Solved

Calculated column value based on another column and rows

Greetings,  I'm trying to make a calculated column that shows the production order status based on the status from all other production orders of the same group. (Production orders have groups, so...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Felizzpe ,

     

    try like:

    column =

    VAR _list =

    CALCULATETABLE(

        VALUES(data[Location]),

        ALLEXCEPT(data, data[Order Group])

    )

    VAR _result =

    IF(_list = "Finished", "Ready", "Not ready")

    RETURN _result

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi Felizzpe ,

 

try like:

column =

VAR _list =

CALCULATETABLE(

    VALUES(data[Location]),

    ALLEXCEPT(data, data[Order Group])

)

VAR _result =

IF(_list = "Finished", "Ready", "Not ready")

RETURN _result