Forum Discussion

matthewtjy's avatar
matthewtjy
Helper I
5 years ago
Solved

Array Formula IF Condition Match, Return Latest Date

Hi, I have 2 tables [SalesRecords] and [SalesPersonID].   [SalesRecords] has every sales transaction for every sales person; [SalesPersonID] has the distinct record of every sales person ID.   H...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    matthewtjy 

    you can create a column

    Column = maxx(FILTER('SalesRecords','SalesRecords'[SalesPersonID]='SaelsPersonID'[SalesPersonID]),'SalesRecords'[SalesDate])

     

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

matthewtjy 

you can create a column

Column = maxx(FILTER('SalesRecords','SalesRecords'[SalesPersonID]='SaelsPersonID'[SalesPersonID]),'SalesRecords'[SalesDate])

 

  • matthewtjy's avatar
    matthewtjy
    Helper I
    5 years ago

    Thanks!