Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to get summarize value from different table

I have three different sheet like  Actuals, M1Data ,M3 Data.   actuals data be like    Market  cat .des   version  Month  SPDCODE   Actuals  ITG5         4             MK         JAN        001 ...
Tanushree_Kapse's avatar
Tanushree_Kapse
Impactful Individual
5 years ago

Hi Anonymous ,

 

You can do this by creating Lookup columns in the Actuals table:
M1 = LOOKUPVALUE(M1(M1), M1(Market), Actuals(Market))
M3=  LOOKUPVALUE(M3(M3), M3(Market), Actuals(Market))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    its not working .  i have three tables i want look up mulitple table value 

    • Tanushree_Kapse's avatar
      Tanushree_Kapse
      Impactful Individual
      5 years ago

      Anonymous ,
      Like Anonymous suggested.... Do this in Power query... by Merging the tables.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      In Power Query you don't look up things. You create joins between tables on any fields you want and then grab from them anything you want. That's the long and short of it.