Forum Discussion
Helper IMultiple Active relation ships to pass Date Parameters
Hi All,
I have a unique issue to which I don't know what to do
I have a Factless Fact table (Equipment Table) with multiple columns in it but it also has 2 input parameters in the table called
p_startdate
p_enddate
I should pass values to this parameters to retrieve any values
Requirement is
The user should be able to use the date slicer and pass values to this p_startdate & p_end date and retrieve the values from the table
What I did so far
- I created a date dimension and populated values from Jan 1, 2000, till Dec 31, 2030
- I joined this Equipment table - Date Dimension
Like p_startdate is joined to Date
p_enddate is joined to date
But only 1 relationship is active
For me to use the Slicer Visualization I should have only 1 date column So this is what I did
Now the report is not filtering any values as there is only 1 active relationship.
Help me please to get this issue resolved ASAP.
2 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
In general however you might want to completely disconnect your Date table and use a technique like GENERATE. See an example here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
Hi anilp,
Power bi only allow one active between two table, this scenario not issue. (You can manually disable active relationship and turn on other one, it is impossible to achieve multiple at same time)
BTW, current power bi can't create relationship from one column to data range who defined by two columns.
Regards,
Xiaoxin Sheng
