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

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

3 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,471 Reputation points
    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/

    2 people found this answer helpful.
    0 comments No comments

  2. Joffrey NURIT 206 Reputation points MVP
    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

    0 comments No comments

  3. 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