Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I want to combine 2 columns from 2 tables after date.
Table 1:
time1 | event1 | (other columns) |
26-01-2023 00:00:32 | 1 | ... |
26-01-2023 00:00:25 | 1 | ... |
25-01-2023 13:02:26 | 0 | ... |
22-01-2023 15:24:01 | 0 | ... |
Table 2:
time2 | event2 | (other columns) |
26-01-2023 00:01:32 | 1 | ... |
23-01-2023 01:20:23 | 0 | ... |
20-01-2023 16:13:36 | 1 | ... |
10-01-2023 12:35:52 | 0 | ... |
Combined table:
time2 | event1 | event2 |
26-01-2023 00:01:32 | 1 | |
26-01-2023 00:00:32 | 1 | |
26-01-2023 00:00:25 | 1 | |
25-01-2023 13:02:26 | 0 | |
23-01-2023 01:20:23 | 0 | |
22-01-2023 15:24:01 | 0 | |
20-01-2023 16:13:36 | 1 | |
10-01-2023 12:35:52 | 0 |
@Anonymous , Power Query Append tables -
Or power query first merge tables and then create a combine date columns
Append and Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query