Forum Discussion
Solved
Lookup Min/Max values from related table
I have two tables: Planning and Tasks. Please see simplified representation in inserted screenshot. I want to have the earliest start date and latest end date for each name in table Planning bas...
If your tables have a many-to-one relationship between Planning and Tasks, the in your Planning table you should be able to create two columns like:
Start for name = CALCULATE(MAX(Tasks[Date]),FILTER(Tasks,[Tasks]=[Project]))
If it is many-to-many, you will need a bridge table that has each task entered only once.
If your tables have a many-to-one relationship between Planning and Tasks, the in your Planning table you should be able to create two columns like:
Start for name = CALCULATE(MAX(Tasks[Date]),FILTER(Tasks,[Tasks]=[Project]))
If it is many-to-many, you will need a bridge table that has each task entered only once.