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