Forum Discussion
how to join table based on between dates
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.)
Create a common timestamp table, join with both table. Have +/- 3 min in one of the table and use a formula as suggested.
Greg_Deckler
Community Champion
Community ChampionPlease 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