Combine two table data which has intersecting time period

[Anonymous]

Hello, I want to ask questions about combining two table data that was pulled from the SQL server.

Two tables have same features but it has different period of time.

I want to combine two tables that meets intersecting time period.

For example, first data looks like this.

And Second Data looks like this.

I want to create a third table 

 

It will be great to get a help how to do this in PowerBI.

Thank you!

[SpartaBI · Accepted solution]

@Anonymous ceate this caclulated table:

Table3 = 
	UNION(
		FILTER(
			Table1,
			Table1[Date] IN VALUES(Table2[Date])
		),
		FILTER(
			Table2,
			Table2[Date] IN VALUES(Table1[Date])
		)
	)

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

It worked! Thank you very much!

[SpartaBI]

@Anonymous my pleasure 🙂
Check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

[Anonymous]

Oh these are interesting reports! I will check it out. Thank you.