I have two tables projects and work log. I need column in project table who is this project designer. So who have first record in work log table with type design. I have relationship One project -> many work_log
I wrote such formula:
Designer = CALCULATE(FIRSTNONBLANK(work_log[Employee];TRUE()); FILTER(ALL(work_log);AND(work_log[project_id]=Project[id]; work_log[type]="Design")))
But unfortunately column is empty. Any suggestions?