Calculate value between two dates

Hi Anonymous 

Please try the below.

Column = 
CALCULATE( 
    MAX('Table A'[Cost]), 
    FILTER(
        RELATEDTABLE('Table A'),
        'Table A'[startDate] <= 'Table B'[date] )
)

Regards,
Mariusz

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

Please try this:

Column =

CALCULATE(

MAX('Query1'[Cost]),

FILTER(

RELATEDTABLE('Query1'),

'Query1'[startDate]<= Query2[date] )

)*Query2[number of Products]