how to join table based on between dates

[Anonymous]

Hi,

I want to join Table1 datetime with Table2 Startdatestamp and Enddate timestamp.

in the chart i want to show the table1 (datetime between table2(Startdatestamp and Enddate timestamp.)

[Greg_Deckler]

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

That being said, perhaps Open Tickets? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

[ImkeF]

Hi @Anonymous  

please check out this post that seems to cover your scenario:

https://community.powerbi.com/t5/Desktop/chart-with-start-and-end-date/td-p/330192 

[Anonymous]

Hi,

I have a single datetime stamp column from both the table

i want to add  column based on mins +3 and min -3(single date between 12/12/2019 12:47 to 12/12/2019 12:53 ) and   from table2 then i will join with table1 datetimestamp.

eg

table1 datetimestamp 12/12/2019 12:50 and the new column from table2 should be single date 

[amitchandak · Accepted solution]

Create a common timestamp table, join with both table. Have +/- 3 min in one of the table and use a formula as suggested.