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
    )
johnt75's avatar
johnt75
Super User
3 years ago

The problem is the "Not submitted". That is text whereas the actual values are datetime. You just need to use the value of the calculation as is, and if it is blank then leave it as blank.

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
    )