Forum Discussion

f4v5cs6oy3vis7j's avatar
f4v5cs6oy3vis7j
Regular Visitor
3 years ago
Solved

Linking tables with multiple parameters

Hello wonderful, brainy people.   I've got a table covering multiple internal entities (e.g. A, B, C) along with some transaction data, including the position in the ledgers where this transaction ...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi f4v5cs6oy3vis7j ,

     

    Please try:

    First create a custom column, here is the M code:

    Table.SelectRows(Table2, (x)=>x[#"FROM ENTRY NO."]<=[#"ENTRY NO."] and x[#"TO ENTRY NO."]>=[#"ENTRY NO."] and x[ENTITY]=[ENTITY])[APPROVER]{0}

    Output:

    Best Regards,

    Jianbo Li

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

  • f4v5cs6oy3vis7j's avatar
    f4v5cs6oy3vis7j
    Regular Visitor
    3 years ago

    Hello amitchandak ,

    Thank you for trying.

    In theory, yes, this should work. But as I mentioned at the start, I have over 10m lines.

    I have applied the formula as you've laid out, but after 6 hours (and I've done this a few times over the course of the last few days), the columns are just taking too long to populate.

     

    Can you suggest another solution to this task? New data will be refreshed every 2 hours and waiting an entire day for this to finish isn't practical.

    Many thanks