Hello,
I have a data modell containing among other things sales date and start date and I need to calculate the number of future startups at any givet date that were sold on or before that date. I would like to show it as a pivot table with year and month as rows and the logic of the measure is that for each row calculate all future startups, i.e. has a startdate that is greater than the maximum date in the row context, and at the same time were sold before or on the maximum date of the row context. How do I set that measure up?
Example data below and also an example of the desired output.
Any help appreciated!
Caj
Example data
<tbody>
</tbody>
Desired output
<tbody>
</tbody>
I have a data modell containing among other things sales date and start date and I need to calculate the number of future startups at any givet date that were sold on or before that date. I would like to show it as a pivot table with year and month as rows and the logic of the measure is that for each row calculate all future startups, i.e. has a startdate that is greater than the maximum date in the row context, and at the same time were sold before or on the maximum date of the row context. How do I set that measure up?
Example data below and also an example of the desired output.
Any help appreciated!
Caj
Example data
| Salesdate | Startdate |
| 2017-01-27 | 2017-02-10 |
| 2017-02-02 | 2017-02-16 |
| 2017-02-14 | 2017-02-28 |
| 2017-01-24 | 2017-03-01 |
| 2017-01-20 | 2017-03-20 |
| 2017-03-27 | 2017-06-01 |
| 2017-01-19 | 2017-10-01 |
| 2017-03-14 | 2017-10-01 |
<tbody>
</tbody>
Desired output
| Month | Future startups |
| 2017 | |
| 1 | 4 |
| 2 | 3 |
| 3 | 3 |
| 4 | 3 |
<tbody>
</tbody>
