Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.)
Solved! Go to Solution.
Create a common timestamp table, join with both table. Have +/- 3 min in one of the table and use a formula as suggested.
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
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |