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 th...
Anonymous ceate this caclulated table:
Table3 = UNION( FILTER( Table1, Table1[Date] IN VALUES(Table2[Date]) ), FILTER( Table2, Table2[Date] IN VALUES(Table1[Date]) ) )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
SpartaBI
Community Champion
Community ChampionAnonymous 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 🙂
Oh these are interesting reports! I will check it out. Thank you.