Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |