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.

Unknown_1's avatar
Unknown_1
Frequent Visitor
2 years ago

My specific Requirement is :

I want distinct values from Column Counter BU and Legal Entity and store those values alphabetically in a new column or table.

Post that I want to check Counter BU and Legal Entity in the newly created table/Column and return the Alphabetically earlier value taken first.

 I hope this helps.