Forum Discussion

LostinDaxland's avatar
LostinDaxland
Regular Visitor
2 years ago
Solved

Probably simple date related lookup

Hi - I'm looking to create a lookup (or rule) wherein a lookup will return the value in a cell that corresponds to a date between both the source and the lookup. I'm not explaining this well, so let'...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    LostinDaxland 

    you can try this

     

    Column =
    VAR _date=maxx(FILTER('Table','Table (2)'[Name]='Table'[Name]&&'Table'[StartDate]<='Table (2)'[Date]),'Table'[StartDate])
    return maxx(FILTER('Table','Table'[Name]='Table (2)'[Name]&&'Table'[StartDate]=_date),'Table'[Department])
     
     
    pls see the attachment below
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

LostinDaxland 

you can try this

 

Column =
VAR _date=maxx(FILTER('Table','Table (2)'[Name]='Table'[Name]&&'Table'[StartDate]<='Table (2)'[Date]),'Table'[StartDate])
return maxx(FILTER('Table','Table'[Name]='Table (2)'[Name]&&'Table'[StartDate]=_date),'Table'[Department])
 
 
pls see the attachment below