I have a module with a number of transactions for different entities. For all of these entities, I have a Unique ID (UID) and a valid from date. I also have a line item that uses the RANK function to rank the transactions. See picture below.
Now to the issue; I need a value in the Valid To line item. This value should be the same as the Valid From for the next transaction. For example, The Valid To for the row #5721 should be 3/27/2019.
My initial idea was to do something like this: Valid To = Valid From [LOOKUP: UID, LOOKUP: Rank order+1] but I didn't manage to get that to work.
Does anyone know how to tackle this issue? Any help is appreciated!
Thanks a lot for your answer! It is really close to what I need, there is just one thing missing:
In my original module, I have several different object, hence why I have a line item called UID. In the print screen I added, I had a filter to show just one UID. Somehow, I need to incorporate that into your solution. How would you do that?
See my results in the image below:
As you can see, I have a few different UID's but they all get the same result...
Thanks a lot for you answer. How would I get the mapping modules to take the UID into account after adding the additional dimension? In my original model, the UID is a list formatted line item. Thanks!