İ have two tables that the table fact and dimension but the dimension table keeps historic data.
Dimension table has a "split" column. Fact table has split_id and that two tables join between split_id and row_date. The join like below.
How can do that in power bi?
ff.Split=ss.Split and ff.RowDate>=ss.StartDate and ff.RowDateOR
ff.Split=ss.Split and ff.RowDate between ss.StartDate and ss.EndDate