cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khoahong Regular Visitor
Regular Visitor

DATE RANGE LOOKUP

Hello everyone,

 

I have two tables like the example below. I want to look up the Campaign into my Product table by the condition that the Launch date is in the period of a Campaign.

 

I want to use LOOKUPVALUE in DAX but dont know how.

 

Can we use DAX or another way to solve it?

 

Thank you

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
iamprajot Established Member
Established Member

Re: DATE RANGE LOOKUP

Here it is, Create a Calculated Column
= CALCULATE(VALUES(Campaign[Campaign]),FILTER(Campaign,'Product'[Launch Date]<Campaign[Stop] && 'Product'[Launch Date]>Campaign[Start]))
3 REPLIES 3
Highlighted
iamprajot Established Member
Established Member

Re: DATE RANGE LOOKUP

Here it is, Create a Calculated Column
= CALCULATE(VALUES(Campaign[Campaign]),FILTER(Campaign,'Product'[Launch Date]<Campaign[Stop] && 'Product'[Launch Date]>Campaign[Start]))
Meghana_123 Frequent Visitor
Frequent Visitor

Re: DATE RANGE LOOKUP

I'm trying to do something similar and for some reason i cannot use the column from the second table in the formula although they have a relationship that is active

Super User
Super User

Re: DATE RANGE LOOKUP

Hi,

Share a dataset and show the expected result.