Forum Discussion

cousinitt13's avatar
cousinitt13
Helper I
2 years ago
Solved

Power Query: Add column from another table where date is between beg and end time

Hello, I struggle with the following code   = Table.AddColumn( fact_mach_speed_TEST, "stoptransid", (Data) => Table.SelectRows( fact_downtime, each [sk_pk_machine_r...
  • AlienSx's avatar
    2 years ago

    Hello, cousinitt13 

     

        Table.AddColumn(
           fact_mach_speed_TEST, "stoptransid",
           (x) => Table.SelectRows(
               fact_downtime, 
               (w) => 
                w[sk_pk_machine_rewinder] = x[sk_pk_machine_rewinder] and 
                x[reptime] >= w[begtime] and 
                x[reptime] <= w[endtime]
           ){0}[stoptransid]?
        )