Forum Discussion

Unknown_1's avatar
Unknown_1
Frequent Visitor
2 years ago
Solved

Dax Help

Hi Team,   I want a dax syntax in which column A is sorted Alphabetically. Column C and Column D are checked or looked up in column A and if that match is found then in the result earlier alphabet...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Unknown_1 ,

     

    Thanks for the reply from 123abc , please allow me to provide another insight: 

     

    Creating Calculated Columns, Writing Expressions

    Result = 
IF (
    MIN ( [LE], [COUNTER LE] ) & MAX ( [LE], [COUNTER LE] ) = [LE] & [COUNTER LE],
    [LE] & [COUNTER LE],
    MIN ( [LE], [COUNTER LE] ) & MAX ( [LE], [COUNTER LE] )
)

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Unknown_1 ,

 

Thanks for the reply from 123abc , please allow me to provide another insight: 

 

Creating Calculated Columns, Writing Expressions

Result = 
IF (
    MIN ( [LE], [COUNTER LE] ) & MAX ( [LE], [COUNTER LE] ) = [LE] & [COUNTER LE],
    [LE] & [COUNTER LE],
    MIN ( [LE], [COUNTER LE] ) & MAX ( [LE], [COUNTER LE] )
)

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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

  • Unknown_1's avatar
    Unknown_1
    Frequent Visitor
    2 years ago

    Hey,

    How to solve the same problem when my COUNTER LE is in a different table.

    Please help me with that.

    Thank you!