topic Need help od DAX Minimum and maximum function in DAX Commands and Tips

Need help od DAX Minimum and maximum function

Anonymous — Mon, 12 Feb 2024 15:54:29 GMT

I want to develop Matrix for person login per day as following but not able to create min and max like below

Note - Date is in column, there is another calulcate column # of login.

Can someone tell me what DAX formula use to create column for min and max.

City	User	1/1	1/2	1/3	1/4	1/5	1/6	min	max
Aatlanta	15	12	3	15	7	5	9	3	15
Chicagot	12	0	1	11	7	5	9	0	11

Re: Need help od DAX Minimum and maximum function

bhanu_gautam — Mon, 12 Feb 2024 16:53:09 GMT

Anonymous , You can try below DAX

for minimum

Min_Login = MINX(VALUES('YourTableName'[User]), CALCULATE(MIN('YourTableName'[# of login])))

For maximum

Max_Login = MAXX(VALUES('YourTableName'[User]), CALCULATE(MAX('YourTableName'[# of login])))

Please accept as solution and give kudos if it helps

Re: Need help od DAX Minimum and maximum function

Anonymous — Wed, 28 Feb 2024 09:41:30 GMT

Hi Anonymous ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create two measures

MaxLogins = CALCULATE( MAX('Table'[Value]), FILTER( 'Table', 'Table'[Column] <> "User" ) )

MinLogins = CALCULATE( MIN('Table'[Value]), ALLEXCEPT('Table', 'Table'[City]) )

Final output

However, this is based on the data I created. In fact matrix is based on the original table adding two columns behind it is not generating it. If this method doesn't work for your file, please provide your pbix file including your table to table relationships, tables, and hide sensitive information ahead of time. This way we can help you faster.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly