Forum Discussion
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...
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 MaxGoLiveActualBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you both for the reply. Both solutions work however, I went with the one using the variables as I may need to add more critieria. Thanks again!