Max value by User in direct query

[Anonymous]

I have username and sale_no column in my user table. Now I want find max of sales_no for each user. In import mode, I have created calculate column as:

=CALCULATE (

MAX ( user[sales_no] ),

ALLEXCEPT ('user',user[full_username]

))

The same thing I want to achieve in direct query. But I came to know in direct query, for calculated column we cannot use calculate function. Is there any way to achieve same via measure or calculated column in direct query.

Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous ,  This can work as a new measure.

And refer to these how to use max value

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e