Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

5 REPLIES 5
Anonymous
Not applicable

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.

Tanushree_Kapse
Impactful Individual
Impactful Individual

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
Not applicable

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

Anonymous
Not applicable

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.

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.