How to merge 2 Tables in PowerBI desktop

[sacheu]

I have a Table with a Column sets to Distrint Value of Table 1 Column Date.

CombineTable = VAR _list =

 DISTINCT( Table1[Date] )

RETURN

 CALENDAR ( MINX ( _list, [Date] ), MAXX ( _list, [Date] ) )

So it looks something like

Date

1/2/2021

1/3/2021

1/4/2021

I have another table Table2 with has Date (but does not have all the dates in CombineTable and other column

Date	Value
1/3/2021	5
1/3/2021	6

And I want to combine the Table2 intoCombine 1, so it looks liek

Date	Value
1/2/2021
1/3/2021	5
1/3/2021	6
1/4/2021

How can I join them together?

[Ashish_Mathur]

Hi,

Create the Calendar table (Combine table) in the Query Editor and then merge into this table, date from Table2.

Hope this helps.

[parry2k · Accepted solution]

@sacheu you can set the relationship of dates columns from new calculated table (you called combineTable) with table 2 on dates and then on any visual,

- get the date column from the combined table and the value from table 2 and you will get the result.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡