Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Last value

Hi this is a classic but can't figure it out...   Two unrelated tables :    - a fact table with some controls on one side    - another table with comments about controls (you can have many commen...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a new column in TAB_Controls like

     

    _Last_Comment = var _max = maxx(FILTER(TAB_Comment, TAB_Comment[ID Control] = TAB_Controls[ID Control] ), TAB_Comment[Date]) 
return maxx(FILTER(TAB_Comment, TAB_Comment[ID Control] = TAB_Controls[ID Control] && TAB_Comment[Date] = _max), TAB_Comment[Comment])

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try a new column in TAB_Controls like

 

_Last_Comment = var _max = maxx(FILTER(TAB_Comment, TAB_Comment[ID Control] = TAB_Controls[ID Control] ), TAB_Comment[Date]) 
return maxx(FILTER(TAB_Comment, TAB_Comment[ID Control] = TAB_Controls[ID Control] && TAB_Comment[Date] = _max), TAB_Comment[Comment])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks amitchandak it works !