measure column based on one-to-may relation

[lexhartman]

Hello,

I'm new to power BI and i really don't know where to begin. My background is PHP programming and a little bit of SQL. If anyone could help me that would be really nice.

I am using a mysql database as "THE" data which i'm working with. For this question there are two main columns:

1. 'task, with columns; id, name, type, etc...
2. 'activity', with columns: id, execution_date, executed_by, etc..

There is a one-to-many relation; one task can have many activities. The relation is already created in Power BI. I'm looking to create a new measure column in the task table. Where i want to put the value of the 'execution_date' from the most recent executed activity (if there is an activity, if there is no activity the value can be null or false...)

Thank you!

[v-yuta-msft]

Hi lexhartman,

What does "the most recent date"  mean? Does it mean one week past, one month past or other logic? You said "a new measure column", do you want to create a measure or a calculate column? In addtion, could you share some sample data to clarify more explictly about your issue?

Regards,

Jimmy Tao