Forum Discussion

MartinC's avatar
MartinC
Icon for Helper I rankHelper I
3 years ago
Solved

How to get a column from table B into Table A?

Hi All, I've been trying all day to get this done and it's just not working for me 😞  Please help! I know it should be easy but I'm struggling... So, I have a table called "Milestones" and another...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    MartinC Not 100% positive I am fully tracking the issue but perhaps this?

    Column =
  VAR __ID = [ID]
  VAR __Result = MAXX(FILTER('UDFS',[ID] = __ID && [UDFID] = 68),[UDFValue])
RETURN
  __Result
MartinC's avatar
MartinC
Icon for Helper I rankHelper I
3 years ago

Greg_Deckler I see my error (but don't know how to fix it) - ID in table UDFS has multiple UDFID values - is there a way to filter for the UDFID value of 68 to give the UDFValue for those only? Thanks 🙂

MartinC's avatar
MartinC
Icon for Helper I rankHelper I
3 years ago