question

11322-4924 avatar image
0 Votes"
11322-4924 asked ·

Complex Join On Power BI

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

not-supported
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

3 Answers

VaibhavChaudhari avatar image
2 Votes"
VaibhavChaudhari answered ·

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

https://community.powerbi.com/


· Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JoffreyNURIT-4769 avatar image
0 Votes"
JoffreyNURIT-4769 answered ·

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

· Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KedarlingannavarSomashekhar-3691 avatar image
0 Votes"
KedarlingannavarSomashekhar-3691 answered ·

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

· 1 · Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image VaibhavChaudhari ·

This thread is tagged with "not-supported" tag. Please post the query in Power BI related forum in the link I mentioned in earlier response.

0 Votes 0 ·