Complex Join On Power BI

11322 1 Reputation point

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,725 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,681 Reputation points

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

    2 people found this answer helpful.
    0 comments No comments

  2. Joffrey NURIT 211 Reputation points


    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

    0 comments No comments

  3. Kedarlingannavar, Somashekhar 1 Reputation point

    I am looking for the support for creating power BI dash board like below link