date intelligence

[ashikts]

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

[v-kelly-msft · Accepted 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!

[PC2790]

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.

[ashikts]

gettting an error "multiple table arguments are not allowed in all functon"

[PC2790]

It works for me. Are you creating a new DAX table from Table Tools section and using the above mentioned code?

[ashikts]

yes ..thats how i did. can you show mw via scrren shot ?

[PC2790]

Here are the screenshots to help:

You can match it with your file and see where it is going wrong.