Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating Dummy Date Field?

I have this table:   It shows over time when someone owned an account. I was provided an entry date only, so I had to come up with a date field to represent their exit date which is simply ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please try this...

     

    ExitDate = 
VAR _ExitDate = CALCULATE(MIN(Test66Lkp[EntryDate]),FILTER(ALL(Test66Lkp),Test66Lkp[Code]=EARLIER(Test66Lkp[Code]) && Test66Lkp[Name] <> EARLIER(Test66Lkp[Name]) && Test66Lkp[EntryDate] > EARLIER(Test66Lkp[EntryDate])))
RETURN IF(_ExitDate=BLANK(),DATE(2100,12,31),_ExitDate)

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please try this...

 

ExitDate = 
VAR _ExitDate = CALCULATE(MIN(Test66Lkp[EntryDate]),FILTER(ALL(Test66Lkp),Test66Lkp[Code]=EARLIER(Test66Lkp[Code]) && Test66Lkp[Name] <> EARLIER(Test66Lkp[Name]) && Test66Lkp[EntryDate] > EARLIER(Test66Lkp[EntryDate])))
RETURN IF(_ExitDate=BLANK(),DATE(2100,12,31),_ExitDate)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PattemManohar Thanks! One question I do have. So let's say Latricia no longer becomes the owner and there is another person after her. Would Latricia's eixt date change to whatever date that was, and would the new person then be assigned 12/31/2100?

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago
    Anonymous Yes it will do. Please change the data by adding another owner and test the same. It should work dynamically.