Related One to Many - Pulling a Date

[Anonymous]

Dear Team,

I am thinking about this wrong so I am looking for some help. My goal is to create a calculated column on the Project Table that pulls in the date the Call was completed.

Project Table
ID	Name	Call Completion Date
1	Project 1	10/5/2020
2	Project 2	1/20/2020
3	Project 3	4/1/2020

Task Table
ID	Name	Completion Date
1	Call	10/5/2020
1	Build	10/6/2020
1	Email	10/7/2020
2	Call	1/20/2020
2	Build	1/21/2020
2	Email	1/22/2020
3	Call	4/1/2020
3	Build	4/2/2020
3	Email	4/3/2020

The column I want to create is in Red. It is a one to many relationships between the tables. I was thinking something along the lines of lookup value?

Interested to see other solutions!

Best,

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this code for a calculated column:

Call Completion Date =

VAR _id = 'Project Table'[ID]

RETURN CALCULATE(MAX('Task Table'[Completion Date]); FILTER(ALL('Task Table'); 'Task Table'[ID ] = _id && 'Task Table'[Name] = "Call"))

Ricardo

[Anonymous]

Thank you Ricardo!