Custom Concatenation measure

[Parthsh93]

Hi

I have to create a custom Lane code in two ways:

1. Origin name - Destination name ( for any next row if NEWorigin = INITIALdestination and NEWdestination=INITIALorigin) It should have a "same code".

2. Origin name - Destination name ( for any next row if NEWorigin = INITIALdestination and NEWdestination=INITIALorigin) It should have a "different code".

Hence I want to come up with a  DAX measure to do so, such that the new data been added can dynamically associate with it.

My Data is as follows in columns:

[Greg_Deckler]

Sorry, what? Your two cases read the same. Sample data, expected output, how to get from a to b. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490