Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help od DAX Minimum and maximum function

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.

 

 

CityUser1/11/21/31/41/51/6minmax
Aatlanta1512315759315
Chicagot120111759011
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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