Forum Discussion
Get lastest date from linked table from specific row.
I have two tables linked, 'ProspectJobs' contains the ID and details of the project. It is linked to the 'mld_MilestoneDetail' which contains many phases for each project 'mdt_id' which have a date 'ActDate'. These tables are linked together via the Jbs_id --> id.
Here is a sample of how the data looks in the mld_MilestoneDetail.
What I am trying to do is to create a new field in the 'ProspectJobs' that returns the latest of the two dates from the 'mld_MilestoneDetail' where the 'mdt_id' = S or 5.
Help is appreciated!
1 Reply
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
