Combine 2 tables - PQ

[cristianml]

Hi,

I need help with with some work I need to solve. I have a main Table with data that I get this updated using "get data from workbook" cause i use a Macro to put many reports from a folder to a Excel tab. So with this Main table I need to add or concatenate this with a Table that have range of period. The problem is that I don't know how.

Main table
Stage	Client id	CSG	Work	Start Date	Type	Projection	SG	Amount
Data	Data	Data	Data	Date	Data	Data	Data	Amount
Data	Data	Data	Data	Date	Data	Data	Data	Amount
Data	Data	Data	Data	Date	Data	Data	Data	Amount

Table option 1
Jan-20	Feb-20	Mar-20	Apr-20	May-20
Calculation	Calculation	Calculation	Calculation	Calculation
Calculation	Calculation	Calculation	Calculation	Calculation
Calculation	Calculation	Calculation	Calculation	Calculation
Calculation	Calculation	Calculation	Calculation	Calculation
Calculation	Calculation	Calculation	Calculation	Calculation

Table option 2
Jan-20	Feb-20	Mar-20
September-15	Q1	FY16
October-15	Q1	FY16
November-15	Q1	FY16
December-15	Q2	FY16

My result table should be:

Result TABLE

Stage

Client id

CSG

Work

Start Date

Type

Projection

SG

Amount

Jan-20

Feb-20

Mar-20

Apr-20

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

Data

Data

Data

Data

Date

Data

Data

Data

Amount

Calculation

Calculation

Calculation

Calculation

How can I join the information to get this result table ?

Thanks !

[Mariusz · Accepted solution]

Hi @cristianml 

You can use Merge Queries as per below.
https://www.youtube.com/watch?v=dTdFt9AvDHA

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Greg_Deckler · Accepted solution]

Hard to follow. Actual sample/example data is better generally. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

In your second table, generally, having columns like that by month/date is difficult. Better to unpivot those columns.

[dax · Accepted solution]

Hi @cristianml , 

I think this is hard to achieve this goal, I didn't view any relationship between fisrt two tables , so I think it is hard to merge it or append it. In addition, I also don't know what is your expected output. So if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

Hard to follow. Actual sample/example data is better generally. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

In your second table, generally, having columns like that by month/date is difficult. Better to unpivot those columns.

[Mariusz · Accepted solution]

Hi @cristianml 

You can use Merge Queries as per below.
https://www.youtube.com/watch?v=dTdFt9AvDHA

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn