How to get summarize value from different table

Question

I have three different sheet like&nbsp; Actuals, M1Data ,M3 Data.&nbsp;actuals data be like&nbsp;&nbsp;Market &nbsp;cat .des&nbsp; &nbsp;version&nbsp; Month&nbsp; SPDCODE&nbsp; &nbsp;Actuals&nbsp;ITG5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500ITG6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 700ITG7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 800AT04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; MAY&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp;M1 data like&nbsp;&nbsp;Market&nbsp; &nbsp; &nbsp;M1ITG6&nbsp; &nbsp; &nbsp; &nbsp;6346&nbsp;&nbsp;&nbsp;M3 data like&nbsp;&nbsp;Market&nbsp; &nbsp; &nbsp;M3AT04&nbsp; &nbsp; &nbsp; &nbsp;5444&nbsp;&nbsp;I Want final data&nbsp; would be like&nbsp;&nbsp;Market &nbsp;cat .des&nbsp; &nbsp;version&nbsp; Month&nbsp; SPDCODE&nbsp; &nbsp;Actuals&nbsp; &nbsp; &nbsp;M1&nbsp; &nbsp; &nbsp;M3&nbsp;ITG5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;0ITG6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 700&nbsp; &nbsp; 6346&nbsp; &nbsp;0ITG7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FAN&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 800&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;0AT04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MK&nbsp; &nbsp; &nbsp; &nbsp; MAY&nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp;5444.&nbsp;&nbsp;any&nbsp; dax fucntion to&nbsp;achieve this ?&nbsp;

tanushree_kapse · Answer

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

anonymous · Answer

Why don't you do this in PQ? PQ is the data preparation tool for PBI. DAX is not. And it's dead easy in PQ in comparison.

anonymous · Answer

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

tanushree_kapse · Answer

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

anonymous · Answer

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.

Forum Discussion

How to get summarize value from different table

5 Replies

Related content

Using CALCULATE to summarize different values

Parameter in summarize

Different Groupby Column Names in Summarize

Date Different return wrong value

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters