Forum Discussion

Kees's avatar
Kees
Icon for Helper I rankHelper 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
Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Kees 

Try the below

 

Search Date = 
var _Agg = SUMMARIZE(TestTable, TestTable[WONumber], "CO", MAX(TestTable[CONumber]), "ES", MAX(TestTable[EstimateID]), "DATE", max(TestTable[Date]))
RETURN
MAXX(_Agg, [DATE])

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin


  • Kees's avatar
    Kees
    Icon for Helper I rankHelper I
    4 years ago

    Could not get it working like this.