Relationship to a key and date range

[vhunyad]

Hello everyone

I have a table structure (partial) of
Campaign (CampaignID, StartDate,EndDate)

Salida (CampaignID,ContactID)

Contacto (ContactID)

Pedido (ContactID, OrderDate).

All tables except Campaign have several million rows. Currently, relationships between tables
Campaign->1:* Departure->*:* (due to address) Customer<->(1:*)Order.
I also have a manual filter for the order date range, which must be set manually on the actual campaign start dates. This way I can't select multiple campaigns with different start-end dates.
I would like to remove the manual date filter and apply the CustomerID and OrderDate filters (between StartDate and EndDate) in the order table. I tried to expand the start-end date ranges to a separate table, but I can't have two active connections between the campaign and the order.

I understand that I could use calculated fields or measures in the campaign table to calculate orders, but I have many other targeting/filters/charts and other related tables that would not be applied/filtered in that case. I prefer to have a type of structure that naturally includes these restrictions and then I could use all my other filters in parallel and have my charts intact.
Thank you for your support,

Viktor

[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

[amitchandak]

I did not get it completely. But you need to create a date dimension and even if there are two dates you need join it with both. One will active one inactive. You can use userelation to activate one

Refer how to deal with two dates : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...