Forum Discussion

yogeshk77's avatar
yogeshk77
Helper I
3 years ago
Solved

Fetch Relative Date from another table

Need help to fetch relevant date field from other table please.   I have below two tables   Release Calendar Table - Showing Date & Release number for some of the dates       Pull Reque...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    CalculatedColumn=IF(PullRequestTable[Merge Status]="succeeded",MINXX(FILTER(ReleaseCalendarTable,(CONTAINSSTRING(ReleaseCalendarTable[Release Number],"SM RL")||CONTAINSSTRING(ReleaseCalendarTable[Release Number],"RM RL"))&&ReleaseCalendarTable[Release Date]>=PullRequestTable[Commit Date]),ReleaseCalendarTable[Release Date]))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

CalculatedColumn=IF(PullRequestTable[Merge Status]="succeeded",MINXX(FILTER(ReleaseCalendarTable,(CONTAINSSTRING(ReleaseCalendarTable[Release Number],"SM RL")||CONTAINSSTRING(ReleaseCalendarTable[Release Number],"RM RL"))&&ReleaseCalendarTable[Release Date]>=PullRequestTable[Commit Date]),ReleaseCalendarTable[Release Date]))

  • yogeshk77's avatar
    yogeshk77
    Helper I
    3 years ago

    You are awesome ! Thanks much !