Forum Discussion
Table.SelectRows with Condition check between two tables
Hi, I have the two tables below Transaction data 1) Person Number 2) Effective Date 3) Amount Set up Data 1) Start Date 2) End Date For each row in transaction record, want to count t...
Hi, arunac first, create a list of end dates. Then add new column to transaction data table that calculations how many list items are >= than current effective date.
ed_list = List.Buffer(#"Set up Data"[End Date]),
count_column = Table.AddColumn(#"Transaction data", "count", each List.Count(List.Select(ed_list, (x) => x >= [Effective Date])))