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 date' by employee, but it returns the maxium for the table.
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.
7 Replies
- amitchandak
Super User
You are using on the same table that is causing an issue. Ref -https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Try using employee from the employee dim
Hi Amit,
Thanks, but I don't have a dimesion table.
Is it possible to find the maximum within the same table?
- amitchandak
Ref this. Seems like same case
https://community.powerbi.com/t5/Desktop/Calculate-subtotal-using-dax/td-p/564402
