Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Max Op Number

I am working on an operations history table.  The key field is work order.  Every work order has multiple operations.  For example:
Work Order      Operation
1801                  10
1801                  20
1802                  10

1802                  20

1802                  30

How do i find the maximun operation for each work order?  The closest i've come is:

Column 2 =
var CurrentWO = Max('pub op_hist'[op_wo_op])
Return
MAXX(
Filter('pub op_hist','pub op_hist'[op_wo_nbr]),
'pub op_hist'[op_wo_op]
)
 
However that only gives me the maximun operation number for all work orders in the table.
Your help is very much appreciated

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous add this measure

     

    Max Op = CALCULATE ( MAX ( Table[Op Number] ), ALLEXCEPT ( Table, Table[Work Order] ) )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous add this measure

     

    Max Op = CALCULATE ( MAX ( Table[Op Number] ), ALLEXCEPT ( Table, Table[Work Order] ) )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I added the following as both a column and measure.  It gives the highest op number for the entire table (2000) intead of the highest for each work order:

      Last Op =
           Calculate(
                Max('pub Op_Max'[op_wo_op)),
                AllExecpt('pub Op_Max','pub Op_Max[op_wo_nbr])
      )


      I suspect it is the ALLEXECPT command but I don't know what to replace it with

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous it will work if you view the data in a table visual, put order number and this new measure and check the result, if not then share how you are using this measure.