Forum Discussion
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 ...
its not working . i have three tables i want look up mulitple table value
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.