Measure to sum up until certain date

luismffaria

New Member
Joined
May 22, 2017
Messages
12
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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
 
Upvote 0
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’)
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,643
Members
452,663
Latest member
MEMEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top