Forum Discussion
Return Earliest Date
Hi
Can you try to add a calculated column on the first table with the following code:
Add a calculated column on table2
Latest Milestone =
VAR Current_Project = Table2[Project Name]
return CALCULATE(MAX(Table1[Milestone]), FILTER(Table1, Table1[Project Name] = Current_Project))table2
Project Name Project Manager Project Start Date Project Finish Date Latest Milestone table1
Project Name Task Milestone hope this helps
It came from the following post:
https://community.powerbi.com/t5/Desktop/DAX-LOOKUPVALUE-with-MAX/td-p/696076
Thank you
Tomas
Hi
Can you try to add a calculated column on the first table with the following code:
Add a calculated column on table2
Latest Milestone =
VAR Current_Project = Table2[Project Name]
return CALCULATE(MAX(Table1[Milestone]), FILTER(Table1, Table1[Project Name] = Current_Project))
table2
| Project Name | Project Manager | Project Start Date | Project Finish Date | Latest Milestone |
table1
| Project Name | Task | Milestone |
hope this helps
It came from the following post:
https://community.powerbi.com/t5/Desktop/DAX-LOOKUPVALUE-with-MAX/td-p/696076
Thank you
Tomas