Forum Discussion

Bi2thelly's avatar
Bi2thelly
Icon for Helper II rankHelper II
1 year ago
Solved

Filter a merged table list to another date column

I'm not sure I'm doing this correctly but I merged two tables together but did not expand as I wanted records from one table tied to the main table. I'm trying to filter the records to get the max co...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Bi2thelly ,
    Based on your description, you can try the following, first, filter the BridgHistory2 table to keep only the rows where GoLive_Actual is less than NOTI_START_DT. Then, find the largest GoLive_Actual date from the filtered table.

    let
    BridgHistory2 = #"BridgHistory2",
    NOTI_START_DT = [NOTI_START_DT],
    FilteredTable = Table.SelectRows(BridgHistory2, each [GoLive_Actual] < NOTI_START_DT),
    MaxGoLiveActual = List.Max(FilteredTable[GoLive_Actual])
in
    MaxGoLiveActual

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Bi2thelly ,
Based on your description, you can try the following, first, filter the BridgHistory2 table to keep only the rows where GoLive_Actual is less than NOTI_START_DT. Then, find the largest GoLive_Actual date from the filtered table.

let
    BridgHistory2 = #"BridgHistory2",
    NOTI_START_DT = [NOTI_START_DT],
    FilteredTable = Table.SelectRows(BridgHistory2, each [GoLive_Actual] < NOTI_START_DT),
    MaxGoLiveActual = List.Max(FilteredTable[GoLive_Actual])
in
    MaxGoLiveActual

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly