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!
Hi ashikts ,
You can create a new DAX table using the below formula:
TableGrouped =
SUMMARIZE (
ALL(ProjectTable[Project],ProjectTable[employee],ProjectTable[work date],ProjectTable[work date],ProjectTable[billing rate],ProjectTable[hours]),
ProjectTable[Project],ProjectTable[employee],
"Start Date",MIN(ProjectTable[work date]),
"End Date",MAX(ProjectTable[work date]),
"Count", SUM(ProjectTable[hours] )
)The result looks like this:
Please provide a Kudos to this answer if you found it interesting.
If it helps to solve your query, please mark it as a solution for others to quickly find it.
gettting an error "multiple table arguments are not allowed in all functon"