If today is between two dates, calculate cost

[Anonymous]

I have a table, where i want to create a measure in DAX which calculate the cost of the items only if both of the two conditions are met, when today is after or equal to the pick up date and when today is less than or equal to the drop off date. I am not getting the right answer, could someone please advice.

items	Pick up date	Drop off date	cost
1	01/01/2024	03/01/2024	£5
2	02/01/2024	07/01/2024	£10
3	03/01/2024	10/01/2024	£15

[AnkitaaMishra · Accepted solution]

Hi @Anonymous ,

Could you please try below DAX to create a measure : 

Total Cost =

SUMX(

    FILTER(

        'Table',

        TODAY() >= 'Table'[Pick up date] &&

        TODAY() <= 'Table'[Drop off date]

    ),

    'Table'[cost]

)

Let me know if this works for you.

Thanks,

Ankita