Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 based on the task information in related table Tasks.
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |