Forum Discussion

Edds01388's avatar
Edds01388
Regular Visitor
2 years ago
Solved

Lookup between two dates

HI I have had a look at verious other similar problems but not been able to figure out how to replicate something I have.   In Excel - I used the following formula: =VLOOKUP(B353,A1:A55,3,TRUE)   w...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Edds01388 ,

    Do you want this:
    I will first show you the sample data:

    Then use DAX to create a new column:

    Title Matched = 
CALCULATE(
    FIRSTNONBLANK('Period ends'[Title], 1),
    FILTER(
        ALL('Period ends'),
        'Safety Tracker 2023'[Date] >= 'Period ends'[Pdatefrom] && 'Safety Tracker 2023'[Date] <= 'Period ends'[Pdateto]
    )
)

    The final result is shown below:

     

    Best Regards,

    Dino Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Edds01388 ,

Do you want this:
I will first show you the sample data:

Then use DAX to create a new column:

Title Matched = 
CALCULATE(
    FIRSTNONBLANK('Period ends'[Title], 1),
    FILTER(
        ALL('Period ends'),
        'Safety Tracker 2023'[Date] >= 'Period ends'[Pdatefrom] && 'Safety Tracker 2023'[Date] <= 'Period ends'[Pdateto]
    )
)

The final result is shown below:

 

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Edds01388 

The column "Title Matched" is just the "Ptitle" you want, sorry I forgot to change the name.

Best Regards,
Dino Tao

  • Edds01388's avatar
    Edds01388
    Regular Visitor
    2 years ago

    You are a Genius!! Fantasic and many many thanks for this 🙂 I am good at excel, but this is something new for me