Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Update New Column with Data from Other Table

Hello. I would like to update a custom column with data from a different table. I have a list of zipcodes with program start dates in one table called DateBeginFootprintZips.   I would like...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Oh, I missed the +1. I'm not sure how much further I can take this without you posting some sample data and expected output because I'm already starting to get confused.

    Column = 
  VAR __zip = [zipcode]
  VAR __Table = FILTER('DateBeginFootprintZips',[Zipcode] = __zip)
RETURN
  IF(COUNTROWS(__Table)+0 = 0, MAX('DateBeginFootprintZips'[DateBegin])+1, MAXX(__Table,[DateBegin]))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Greg,

Thanks for this.  Certainly on the right track.  The start date of 6/6 and 6/13 are only assigned to the corresponding zipcodes.  However, all other zipcodes are assigned to the 8/1 date.  How do I update so that just the corresponding zipcodes are assigned the 8/1, leaving all other zipcodes with no current start date to be assigned 8/2 (Max BeginDate + 1 one day)?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Oh, I missed the +1. I'm not sure how much further I can take this without you posting some sample data and expected output because I'm already starting to get confused.

Column = 
  VAR __zip = [zipcode]
  VAR __Table = FILTER('DateBeginFootprintZips',[Zipcode] = __zip)
RETURN
  IF(COUNTROWS(__Table)+0 = 0, MAX('DateBeginFootprintZips'[DateBegin])+1, MAXX(__Table,[DateBegin]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Super User Greg!