Forum Discussion

svnsramesh's avatar
svnsramesh
New Member
4 years ago
Solved

Distinct with two columns in reverse in DAX

Thank you forsolving this
Need Help
  • lukiz84's avatar
    lukiz84
    4 years ago
    NewColumn := 
   IF( 
       'Table'[Arrival Airport Code] < 'Table'[Departure Airport Code], 
       'Table'[Arrival Airport Code] & 'Table'[Departure Airport Code],
       'Table'[Departure Airport Code] & 'Table'[Arrival Airport Code]
   )
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
4 years ago
NewColumn := 
   IF( 
       'Table'[Arrival Airport Code] < 'Table'[Departure Airport Code], 
       'Table'[Arrival Airport Code] & 'Table'[Departure Airport Code],
       'Table'[Departure Airport Code] & 'Table'[Arrival Airport Code]
   )