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
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors