DAX - Filtering between Dates

[Babycakes]

Good afternoon,

I am creating a DAX but need it to now filter that if these dates

"column x Date" is between column A Date and column B Date, to only include this data

Product Code =

CALCULATE(

    SUM('GENIUS Invoices + Claims Report'[Amount excl. GST]),

    FILTER(

        ALLSELECTED('GENIUS Invoices + Claims Report'[Key],'GENIUS Invoices + Claims Report'[Support Item Number]),

        ISONORAFTER('GENIUS Invoices + Claims Report'[Support Item Number],MAX('GENIUS Schedule of Support Expo'[Support Item Number]),DESC)

    ))

Can you please assist?

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.

[lbendlin]

There's a DATESBETWEEN syntax sugar function.  Or do it manually.

[Babycakes]

How could i incorporate this?

[lbendlin]

Here's the documentation: DATESBETWEEN function (DAX) - DAX | Microsoft Learn