Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago
Solved

Getting closest date

Hi,   I have 2 tables below. I want to bring over the closest checked processed date after the check deposit date for each account.      This is what the end results should look like:  ...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Sorry, try this

    =calculate(min('Table2'[Check Processed]),filter('Table2','Table2'[Account]=earlier('Table1'[Account])&&'Table2'[Check Processed]>earlier('Table1'[Check deposited])))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Write this calculated column formula in Table1

=calculate(min('Table2'[Check Processed]),filter('Table2','Table2'[Account]=earlier('Table2'[Account])&&'Table2'[Check Processed]>earlier('Table1'[Check deposited])))

Hope this helps.

  • PowerBI123456's avatar
    PowerBI123456
    Post Partisan
    5 years ago

    Ashish_Mathur Thank you! But its not working for me, after the first earlier, its only letting me select from table 1. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Sorry, try this

      =calculate(min('Table2'[Check Processed]),filter('Table2','Table2'[Account]=earlier('Table1'[Account])&&'Table2'[Check Processed]>earlier('Table1'[Check deposited])))