Forum Discussion

Kees's avatar
Kees
Helper I
4 years ago
Solved

Conditional Look Up / Search Date in other table

Hi,   I have tried several functions, lookupvalue, Max, Maxx and other options suggeted in this forum, but I seem not be able to find the right solution.  In regard to the below screenshot: I...
Need Help
Tips and Tricks
  • Kees's avatar
    Kees
    4 years ago

    Found via coworker the soution.

     

    Create a Measure, content;

     

    Last CO Prod Del Date = Calculate(
        LASTDATE(CO[CO Prod Delivery Date]),
        KEEPFILTERS(WO)
    )
     
    That did the trick
Kees's avatar
Kees
Helper I
4 years ago

Found via coworker the soution.

 

Create a Measure, content;

 

Last CO Prod Del Date = Calculate(
    LASTDATE(CO[CO Prod Delivery Date]),
    KEEPFILTERS(WO)
)
 
That did the trick