Complex Join On Power BI

Question

Hi ,

İ 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.RowDate<=ss.EndDate
OR
ff.Split=ss.Split and ff.RowDate between ss.StartDate and ss.EndDate

Answer 1

Current Q&A platform doesn't support PBI. For quicker response, do post the question on below dedicated forum:

https://community.powerbi.com/

Answer 2

Hi,

You can do this in multiple ways. A simple way can be:

• Join the 2 tables (ff.Split=ss.Split)
• Use a calculated column to create a boolean with the conditional ff.RowDate>=ss.StartDate and ff.RowDate
• filter on condition = true

the result was a table with the join, which display only data you want to see

Answer 3

I am looking for the support for creating power BI dash board like below link
https://community.powerbi.com/t5/Data-Stories-Gallery/Executive-Insights-by-Decisive-Data/td-p/181742