Forum Discussion

newgirl's avatar
newgirl
Post Patron
4 years ago
Solved

Lookup using Start Date

Hello! I have my main table below: Main Table Transaction Date Volume Client Product 1-Jan-22 10 A ballpen 1-Jan-22 20 B notebook 10-Jan-22 30 B ballpen 28-Feb-22 40 A ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    newgirl 

    pls try this

    Column = maxx(FILTER('Supporting Table','Main Table'[Transaction Date]>='Supporting Table'[Start Date]&&'Main Table'[Transaction Date]<='Supporting Table'[End Date]&&'Main Table'[Product]='Supporting Table'[Product]),'Supporting Table'[Category])

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

newgirl 

pls try this

Column = maxx(FILTER('Supporting Table','Main Table'[Transaction Date]>='Supporting Table'[Start Date]&&'Main Table'[Transaction Date]<='Supporting Table'[End Date]&&'Main Table'[Product]='Supporting Table'[Product]),'Supporting Table'[Category])

newgirl's avatar
newgirl
Post Patron
4 years ago

Thank you so much!! This worked!

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    you are welcome