Select Workorder with least MIN Value in context to a Part number

Unni · November 30, 2020, 2:36pm

For List of parts that are short for many Job’s or Workorders , i wish to select the WO which has the least number of Days Available to be completed , from a group of many Workorder that require the same part

Demand Data.pbix (102.4 KB)

Melissa · November 30, 2020, 3:01pm

Hi @Unni,

Welcome to the Forum.

Based on your description I created this measure:

First Due WO = 
VAR WOlist = 
    SELECTCOLUMNS( 'Work Order Table Demo', 
        "@Item", [component_code],
        "@WO", [works_order],
        "@Due", [due_date]
    )
VAR FirstWoDate = TOPN( 1, WOlist, [@Due], ASC )
VAR Result = CONCATENATEX( FirstWoDate, [@WO], ", ")
RETURN

IF( ISINSCOPE( 'Main Sheet Demo'[Product] ),
    Result
)

With this result.

I hope this is helpful.

Unni · December 1, 2020, 2:45am

Melissa:

First Due WO = 
VAR WOlist = 
    SELECTCOLUMNS( 'Work Order Table Demo', 
        "@Item", [component_code],
        "@WO", [works_order],
        "@Due", [due_date]
    )
VAR FirstWoDate = TOPN( 1, WOlist, [@Due], ASC )
VAR Result = CONCATENATEX( FirstWoDate, [@WO], ", ")
RETURN

IF( ISINSCOPE( 'Main Sheet Demo'[Product] ),
    Result
)

Hi Melissa it very helpful your logic …thank you very much…for the solution as well as the welcome it is great to see such fast response