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.

Edds01388's avatar
Edds01388
Regular Visitor
2 years ago

Manged to get the chart created thank you again- couple of minor glitches which I am trying to figure out

1. X axes- getting this in a decent correct order  1,2,3,4 not how its showing

2. pulling a few wrong dates (but think I know why)