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

The formula is as follows:

 

if(CALCULATE(LASTNONBLANK('Affiliate Submission'[Completion time].[Date],1),FILTER(ALL('Affiliate Submission'),'Affiliate List'[Column]='Affiliate Submission'[Concat Search]))=blank(),CALCULATE(LASTNONBLANK('Affiliate Submission'[Completion time].[Date],1),FILTER(ALL('Affiliate Submission'),'Affiliate List'[Column]='Affiliate Submission'[Concat Search])))
 
I am not receving any errors, however it is not pulling any data. Just blanks.