Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

 

Need Help
  • iamprajot's avatar
    iamprajot
    8 years ago
    Here it is, Create a Calculated Column
    = CALCULATE(VALUES(Campaign[Campaign]),FILTER(Campaign,'Product'[Launch Date]<Campaign[Stop] && 'Product'[Launch Date]>Campaign[Start]))

5 Replies

  • iamprajot's avatar
    iamprajot
    Responsive Resident
    8 years ago
    Here it is, Create a Calculated Column
    = CALCULATE(VALUES(Campaign[Campaign]),FILTER(Campaign,'Product'[Launch Date]<Campaign[Stop] && 'Product'[Launch Date]>Campaign[Start]))
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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