Combine two tables and calculate a measure

[Krishna1992]

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.

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.

[Anonymous]

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

[Krishna1992]

Hi @Anonymous,

Thanks for the reply.

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

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

	Primary Key	Revenue	Type
Table1	S.NO	xxxx	Bottle
Table2	S.NO	xxxx	Phone
Table3	S.NO	xxxx	Mouse
Table4	S.NO	xxxx	Charger
	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.