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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors