Looking up values from another tables and date is within a date range

[larrytam]

HI

I am a bit stuck in getting the "Tare(Tonnes)" from the right table to the left one given the "Truck Combination" = "LinkedTruckID" and the "Docket Date" is between "start date" and "end date". 

Appreciate for any help

[Anonymous · Accepted solution]

Hi @larrytam ,

Please try this measure:

Measure = 
CALCULATE(
    [Tare(Tonnes)],
    'Table2'[Linked TuckID]=SELECTEDVALUE('Table1'[Truck Combination])
    && 'Table2'[start date]<=SELECTEDVALUE('Table1'[Docket Date])
    && 'Table2'[end date]>=SELECTEDVALUE('Table1'[Docket Date])
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[larrytam]

It works, appreciate for your help