ExcelingInLife
New Member
- Joined
- May 1, 2020
- Messages
- 7
Hello,
I was hoping someone would be able to help, I am looking to incorporate a measure for a cube value formula in excel where the date input is dynamic based on where the formula is.
Essentially I am trying to use the data below to say based on the date selection in excel (lets use 2/28/2020), I want to know the total payment amount in February for invoices with a date prior to February 2020.
I started with the below measure, but clearly it doesn't work, any ideas?
calculate([PaymentTotal], Data[DateType] = "Invoice Date", PaymentData[DateValue] < 'Date'[Date])
I was hoping someone would be able to help, I am looking to incorporate a measure for a cube value formula in excel where the date input is dynamic based on where the formula is.
Essentially I am trying to use the data below to say based on the date selection in excel (lets use 2/28/2020), I want to know the total payment amount in February for invoices with a date prior to February 2020.
I started with the below measure, but clearly it doesn't work, any ideas?
calculate([PaymentTotal], Data[DateType] = "Invoice Date", PaymentData[DateValue] < 'Date'[Date])
| Name | Inv Amt | Payment Amount | DateType | DateValue |
| ClientA | 30 | -30 | Invoice Date | 1/31/2020 |
| dbfbf | 30 | -30 | Payment Posted | 2/7/2020 |
| ClientB | 30 | -30 | Invoice Date | 1/31/2020 |
| fubfkhb | 30 | -30 | Payment Posted | 2/7/2020 |
| fnjfkj | 30 | -30 | Invoice Date | 1/31/2020 |
| fnl | 30 | -30 | Payment Posted | 2/7/2020 |
