Count and Getting Max

[Anonymous]

Hi everyone

I'm loosing my mind on a simple case, but I can't find why it doesn't work

So I have a table like this one:

Project Type	User	#Count	ProjectName	Start	Finish
A	Architecture	2	Test	13/01/2016	13/01/2016
A	Architecture	1	Test	14/01/2016	13/01/2016
A	Architecture	2	Test	14/01/2016	14/01/2016
A	Architecture	1	Test	15/01/2016	14/01/2016
B	Software	5	Test	13/01/2016	15/01/2016
B	Software	5	Test	14/01/2016	15/01/2016
A	Project Manager	2	Test	13/01/2016	15/01/2016
A	Project Manager	2	Test	13/01/2016	14/01/2016
A	Project Manager	2	Test	14/01/2016	14/01/2016

From this table, I'd like to get something like this one:

A	Architecture	5	Test	13/01/2016	14/01/2016
B	Software	10	Test	13/01/2016	15/01/2016
A	Project Manager	4	Test	13/01/2016	15/01/2016
B	Project Manager	2	Test	14/01/2016	14/01/2016

So I'd like to count the number of architecture, Sofwtare and Project Manager and take the max date in my last column

So I've tried things like Max=Calculate(MAX([Finish]),ALLEXECPT([USER])) but it didn't work

Any idea of what I'm doing wrong?

Thank you for your help

Kr,

Tom

[parry2k · Accepted solution]

@Anonymous this should work, basically give max of finish date for the user against all the records of that user

Max=Calculate(MAX([Finish]),ALLEXCEPT(Table, [USER])) 

[Anonymous]

Ok so to do work, I had to add another measure for my Begin date column

Weird but now it's working

[parry2k]

@Anonymous 🙂