Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Text contains from a different table and returning the latest field

Hi, My aim is to produce a visual that will show customer payment days (ie how long it took them to pay the full invoice) I have 2 tables. Invoices and Payments. The invoices have a unique audit n...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    let InvAuditNo=[AutoIdx]
    in

    List.Max(
    Table.SelectRows(CustomerPayments,
    each Text.Contains([cAllocs],InvAuditNo))
    [TxDate]
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Perfect, Thank you SO much 🙂