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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

MartinC You could try a Merge step in Power Query Editor or perhaps try this:

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

    Greg_Deckler this puts an x in the column (so progress, thanks!) but I need the values from the column?