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!View all the Fabric Data Days sessions on demand. View schedule
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!