Forum Discussion

Daniel_Fdrvc's avatar
Daniel_Fdrvc
Icon for Helper I rankHelper I
4 years ago
Solved

Add latest value from one table to another

Hello,   i've got some issues with adding latest value from one table to another, maybe someone could help me. So.. I've created new calculated table that stores distinct UNIQUE ID values from two ...
Need Help
  • Daniel_Fdrvc's avatar
    Daniel_Fdrvc
    4 years ago

    You won't believe... because latest value for same ID is always the same, even if that ID appears two or more times, simple lookupvalue function solves me everything. 

Daniel_Fdrvc's avatar
Daniel_Fdrvc
Icon for Helper I rankHelper I
4 years ago

Greg_Deckler this add's to all unique id's in 1 table same value, for example - yes 😞

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Daniel_Fdrvc I assumed the tables were related to one another, try:

Latest value column =
  VAR __ID = [Unique ID]
  VAR __Rows = SELECTCOLUMNS(FILTER('Table2',[ID] = __ID),"__LatestValues",[Latest value])
RETURN
  IF("no" IN __Rows,"no","yes")