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 ,

I apologize that I may not have understood which column you were hoping to compare. Is the 'tracker' [Date] column being compared to see if the date is between "Pdatefrom" and "Pdateto"? If so, please provide some additional data for the 'tracker' [Date] column.
Also I'm not sure what the "Period" column does in your screenshot?

Based on the needs you describe, I will give you a reference DAX with which to create a new column:

PTitle = 
IF(
   'Table'[Date] >= 'periods'[Pdatefrom] && 'Table'[Date] <= 'periods'[Pdateto],
   TRUE(),
   FALSE()
)

You can change this DAX to suit your own situation.

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.