Forum Discussion
Combine two table data which has intersecting time period
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!
Anonymous ceate this caclulated table:
Table3 = UNION( FILTER( Table1, Table1[Date] IN VALUES(Table2[Date]) ), FILTER( Table2, Table2[Date] IN VALUES(Table1[Date]) ) )
4 Replies
Anonymous ceate this caclulated table:
Table3 = UNION( FILTER( Table1, Table1[Date] IN VALUES(Table2[Date]) ), FILTER( Table2, Table2[Date] IN VALUES(Table1[Date]) ) )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 🙂