How to join facts with facts with datetime

[Anonymous]

Hi,

My Fact1 and Fact2 have datetime column, I need to join fact2 datetime with fact1 datetime.

fact1=01/01/2020 12:14 need to join with fact 2= 01/01/2020 12:12 and 01/01/2020 12:15 

that means +3 or -3 mins from fact 2

[amitchandak · Accepted solution]

The best way is two dimension tables One Date and One time.

Others do the cartesian of date and time and create a table join that.

time table

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[ImkeF]

Use a joint Dimension table instead.
I've never seen a model yet, where joining fact-tables that way made sense.