Forum Discussion

matthewtjy's avatar
matthewtjy
Icon for Helper I rankHelper 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])

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Write this calculated column formula in the SalesPersonID table

=calculate(max(slesrecords[alesdate]),filter(salespersonid,salespersonid[salesperonid]=earlier(salesrecords[salespersonid])))

Hope this helps.