Forum Discussion

AC2023's avatar
AC2023
New Member
2 years ago

DAX Lookup value in the same table

Hi, I tried lookupvalue and calculate but can't get the result I need.  Any help is appreciated.  Thanks! Assigned = CALCULATE(FIRSTNONBLANK(Table[Assignee],1),FILTER(ALL(Table[Assignee]),Table[...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  AC2023 ,

 

 

Here are the steps you can follow：

1. Create measure.

Measure =
MAXX(
    FILTER(ALL('Table'),
    'Table'[EndDate] in SELECTCOLUMNS('Table',"1",[AssigneeEndDate])),[StartDate])
Measure 2 =
MAXX(
    FILTER(ALL('Table'),
    [Measure]=MAX('Table'[StartDate])),[Assignee])

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

AC2023's avatar
AC2023
New Member
2 years ago

Hi Anonymous,

 

Thank you!  This works great with the sample data I provided, and it gives the correct desired result.  However, when I applied this to my actual table which is huge, I got the error message "Resources Exceeded.  This visual has exceeded the available resources.  Try filtering to decrease the amount of data displayed."  Any ideas how to fix this error?