Forum Discussion

Nick221_'s avatar
Nick221_
Frequent Visitor
3 years ago
Solved

Pulling data between two tables.

Below is the formula I am using on multiple columns. It will pull data from one table to another by my two Concat search coulmns (Concat Search & Column). However, I wanted to use this same formula f...
  • johnt75's avatar
    johnt75
    3 years ago

    If the column is being added to the Affiliate List table you can try

    Completion Time =
VAR CurrentColumn = 'Affiliate List'[Column]
RETURN
    CALCULATE (
        MAX ( 'Affiliate Submission'[Completion time].[Date] ),
        REMOVEFILTERS ( 'Affiliate Submission' ),
        'Affiliate Submission'[Concat Search] = CurrentColumn
    )
Nick221_'s avatar
Nick221_
Frequent Visitor
3 years ago

When I remove the "Not Submitted" text, I am still receiving the same error.

johnt75's avatar
johnt75
Super User
3 years ago

If the column is being added to the Affiliate List table you can try

Completion Time =
VAR CurrentColumn = 'Affiliate List'[Column]
RETURN
    CALCULATE (
        MAX ( 'Affiliate Submission'[Completion time].[Date] ),
        REMOVEFILTERS ( 'Affiliate Submission' ),
        'Affiliate Submission'[Concat Search] = CurrentColumn
    )