cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freedumz
Frequent Visitor

Count and Getting Max

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 TypeUser#CountProjectNameStartFinish
AArchitecture2Test13/01/201613/01/2016
AArchitecture1Test14/01/201613/01/2016
AArchitecture2Test14/01/201614/01/2016
AArchitecture1Test15/01/201614/01/2016
BSoftware5Test13/01/201615/01/2016
BSoftware5Test14/01/201615/01/2016
AProject Manager2Test13/01/201615/01/2016
AProject Manager2Test13/01/201614/01/2016

A

Project Manager2Test14/01/201614/01/2016

 

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

 

AArchitecture5Test13/01/201614/01/2016
BSoftware10Test13/01/201615/01/2016
AProject Manager4Test13/01/201615/01/2016
BProject Manager2Test14/01/201614/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

1 ACCEPTED SOLUTION
parry2k
Super User III
Super User III

@freedumz 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])) 





Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
parry2k
Super User III
Super User III

@freedumz 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])) 





Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

freedumz
Frequent Visitor

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

Weird but now it's working

@freedumz 🙂 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors