Forum Discussion
Solved
date intelligence
Hello All, Thanks for the great support from the community.As a beginner im very thankful to this . Once again needed a help from here. i have a data like this: Project employee work date b...
Hi ashikts ,
Create 2 measures as below:
_Start date = CALCULATE(MIN('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))_End date = CALCULATE(MAX('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
