Multiple Active relation ships to pass Date Parameters

[anilp]

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 

1. I created a date dimension and populated values from Jan 1, 2000, till Dec 31, 2030
2. 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.

[Anonymous]

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

[Greg_Deckler]

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