topic How to get summarize value from different table in DAX Commands and Tips

How to get summarize value from different table

Anonymous — Thu, 15 Jul 2021 07:20:28 GMT

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 500

ITG6 4 MK JAN 001 700

ITG7 4 MK FAN 001 800

AT04 4 MK MAY 001 500

M1 data like

Market M1

ITG6 6346

M3 data like

Market M3

AT04 5444

I Want final data would be like

Market cat .des version Month SPDCODE Actuals M1 M3

ITG5 4 MK JAN 001 500 0 0

ITG6 4 MK JAN 001 700 6346 0

ITG7 4 MK FAN 001 800 0 0

AT04 4 MK MAY 001 500 0 5444.

any dax fucntion to achieve this ?

Re: How to get summarize value from different table

Tanushree_Kapse — Thu, 15 Jul 2021 09:49:12 GMT

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))

Re: How to get summarize value from different table

Anonymous — Thu, 15 Jul 2021 10:22:02 GMT

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.

Re: How to get summarize value from different table

Anonymous — Thu, 15 Jul 2021 10:44:18 GMT

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

Re: How to get summarize value from different table

Tanushree_Kapse — Thu, 15 Jul 2021 10:54:32 GMT

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

Re: How to get summarize value from different table

Anonymous — Thu, 15 Jul 2021 11:28:56 GMT

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.