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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Krishna1992
Helper I
Helper I

Combine two tables and calculate a measure

Hello Everyone,

 

I am new to PowerBI.

I have 3 questions.

 

1. Currently I have 3 different reports. I am struggling to upload at same time. I used excel upload everytime as of now. But in future how to upload in single go. 

 

I tried using folder upload, but it will combine if all files contain same format(Correct me if I am wrong).

 

2. After uploading files powerbi automatically create relationship between tables. PFA for the screenshot. If I want to have relation between Despatch and Exportbilling it says that "Key contains Null value". Please help me how can I create relationship between the two.

 

relation.png

 

 

3. After creating relationship I need to find overall revenue present in 3 tables. How to perform calculated column to sum all 3 values.

 

Please help me out.

 

Thanks.

 

 

2 REPLIES 2
Anonymous
Not applicable

HI @Krishna1992,

 

#1. Which upload you mean? Get data to power bi desktop? If this is a case, you can only get data from one file.

 

#2. I'd like to suggest you remove duplicate records and blank records in query editor before create relationship.

Remove duplicates (Power Query)

 

#3. Please share some sample data with expected result for test.

Regards,

Xiaoxin Sheng

Hi @Anonymous,

 

Thanks for the reply.

 

I used your suggestion on question 2, created relationship. Please find the below screenshot.

Relation2.png

 

By using this relationship I need to achieve as below table,

 

 Primary KeyRevenueType
Table1S.NOxxxxBottle
Table2S.NOxxxxPhone
Table3S.NOxxxxMouse
Table4S.NOxxxxCharger
 SUM=REV1+REV2+REV3+REV4

 

I used sum(rev)+sum(rev2)+sum(rev3)+sum(rev4), but it throws the overall sum of values(same value) in each row, which means there is missing relation between table. Correct me if I am wrong.

 

How to establish and create report by establishing relationship.

 

Also how to create a slicer with type, so that If I filter one type appropriate report/data needs to filtered.

 

Do I need to create any master table for this or with this can I achieve this result?

 

Please help..

 

please let me know how to approach on this.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors