Complex Join On Power BI

11322 1 Reputation point
2019-12-17T13:34:39.767+00:00

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

Community Center | Not monitored
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 39,016 Reputation points Volunteer Moderator
    2019-12-17T13:59:19.573+00:00

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

    https://community.powerbi.com/

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Kedarlingannavar, Somashekhar 1 Reputation point
    2020-03-05T09:49:46.72+00:00

    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

    Was this answer helpful?

  3. Joffrey NURIT 211 Reputation points
    2019-12-18T22:13:44.63+00:00

    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

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.