Measure to sum up until certain date

[luismffaria]

Hello,
I'm not that familiar with measures in data models.
Currently I have a measure call "TotalPayments" which is basically summing all the payments for all the projects that are in the table in the data model. With that then I can create a table in excel via a cube formula for the total payments per project.
However, I wanted to sum the payments since begining until a certain date - and this date I would define in a cell in the excel file, in order to know for each project how much it is spend until for instance 31.jan.2023 (once again, this date I would define in the excel file, so it could be volatile).
How could I do it?
Thank you for your help in advance

 

[ExceLoki]

what version of excel are you using?
you are able to add that to your profile to make it easier for others to know how to best help

 

[luismffaria]

what version of excel are you using?
you are able to add that to your profile to make it easier for others to know how to best help

I have office365, so the last version available

 

[Fluff]

I have office365,

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)