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.
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 | billing rate | cost rate | hours |
php | ashik | 04/01/2021 | 10 | 20 | 2 |
php | ashik | 05/01/2021 | 10 | 20 | 3 |
php | ashik | 06/01/2021 | 10 | 20 | 2 |
java | amit | 04/01/2021 | 14 | 15 | 3 |
java | amit | 04/01/2021 | 14 | 15 | 2 |
java | amit | 04/01/2021 | 14 | 15 | 1 |
php | rahul | 04/01/2021 | 12 | 20 | 2 |
php | rahul | 05/01/2021 | 12 | 20 | 3 |
My data is like that .We have more than 100 employees and diffrent project details.
what i want is something like that.
Project | employee | start date | end date | bill rate | hours |
php | ashik | 04/01/2021 | 06/01/2021 | 10 | 7 |
php | rahul | 04/01/2021 | 05/01/2021 | 12 | 5 |
java | amit | 04/01/2021 | 06/01/2021 | 14 | 6 |
Please help me to resolve it
Solved! Go to Solution.
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,
Kelly
Did I answer your question? Mark my post as a solution!
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,
Kelly
Did 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"
It works for me. Are you creating a new DAX table from Table Tools section and using the above mentioned code?
yes ..thats how i did. can you show mw via scrren shot ?
Here are the screenshots to help:
You can match it with your file and see where it is going wrong.
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 |
---|---|
108 | |
98 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |