Lookup value per date

HEW , you can use the measure below:

PricePerStartOfMonth =
VAR c_article = SELECTEDVALUE ( 'Table'[Article no.] )
VAR c_date = SELECTEDVALUE ( Dates[StartOfMonth] )
RETURN
    CALCULATE (
        MAX ( 'Table'[ Price ] ),
        'Table'[Article no.] = c_article,
        c_date >= 'Table'[Date start],
        c_date <= 'Table'[Date end]
    )

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

I am a Ukrainian living in Ukraine. Please, help us to survive! Please, Ask your government to react!
Here are official ways you can support us financially (accounts with multiple currencies):
https://bank.gov.ua/ua/about/support-the-armed-forces

USD:
BENEFICIARY: National Bank of Ukraine
BENEFICIARY BIC: NBUA UA UX
BENEFICIARY ADDRESS: 9 Instytutska St, Kyiv, 01601, Ukraine
ACCOUNT NUMBER: 400807238
BENEFICIARY BANK NAME: JP MORGAN CHASE BANK, New York
BENEFICIARY BANK BIC: CHASUS33
ABA 0210 0002 1
BENEFICIARY BANK ADDRESS: 383 Madison Avenue, New York, NY 10017, USA
PURPOSE OF PAYMENT: for crediting account 47330992708

Accounts details for other currencies (EUR|GBP|CHF|AUD|CAD|PLN) can be found here: https://bank.gov.ua/ua/about/support-the-armed-forces