Forum Discussion
Solved
Max by group by not working
Hi All, Please can I know why my max by group by is not working? I reffered to various threads in here and they have done the same , but doesn't work for me. I need to find the maximum of 'Changed...
I just opened a new power BI and connected, my intial formula works!
max date = CALCULATE(MAX(Sheet1[changed date]),ALLEXCEPT(Sheet1,Sheet1[employee]))Thanks amit for your time and suggestions.
amitchandak
Super User
Super UserShould be something like this in your case
Max Employee = CALCULATE(max(sheet1[change Date]),FILTER(ALL(sheet1),sheet1[employee]=SELECTEDVALUE(sheet1[employee])))
So it might work as a measure
I just opened a new power BI and connected, my intial formula works!
max date = CALCULATE(MAX(Sheet1[changed date]),ALLEXCEPT(Sheet1,Sheet1[employee]))
Thanks amit for your time and suggestions.