Calculated Column from Another Table

[Anonymous]

I have two tables with application ID in both table having relationship.

First Table

Application ID	Closed DateTime	Tat	Closed Flag
1	23-09-2021	30	No
1	24-09-2021	45	Yes
1	25-09-2021	56	Yes

Second Table

Application ID	TAT (Calculated Col)
1	56

I need to create a calculated column "TAT" in the second table which brings the TAT value for a maximum ClosedDateTime of a Application ID and Closed Flag should be "Yes".

Please help me with DAX for this. 

[Greg_Deckler · Accepted solution]

@Anonymous This is essentially Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community. In your case:

TAT Column =
  VAR __Date = MAXX(FILTER(RELATEDTABLE('First Table'),[Closed Flag]="Yes"),[Closed DateTime])
  VAR __Tat = MAXX(FILTER(RELATEDTABLE('First Table'),[Closed Flag]="Yes" && [Closed DateTime]=__Date),[Tat])
RETURN
  __Tat