Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Custom Concatenation measure

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: