Hi,
I need to show monthly subscription for a product, but I have only been provided the product name, the monthly product charge (constant, same amount each month), the start date and the end date. Something like below:
| Product | Start Date | End Date | Monthly Amount |
| ABC | 9/1/2023 | 10/1/2024 | $500 |
| DEF | 10/1/2023 | 11/1/2024 | $900 |
| GHI | 11/1/2023 | 12/1/2024 | $1,200 |
I am hoping to produce something like this:
| | 1-Sep-23 | 1-Oct-23 | 1-Nov-23 | 1-Dec-23 | 1-Jan-24 | 1-Feb-24 | 1-Mar-24 | 1-Apr-24 | 1-May-24 | 1-Jun-24 | 1-Jul-24 | 1-Aug-24 | 1-Sep-24 | 1-Oct-24 |
| ABC | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| DEF | | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
| GHI | | | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 | $1200 |
As I would then like to produce a chart.
Is there something in DAX I could write that would help me achieve what I am after? My reason for asking is that the data I have is only going to increase in volume, so it would be really nice to put together some function that enables me to take the monthly amount and apply it to each month. Hopefully that makes sense. 🙂
Any help would be greatly appreciated. I am a DAX newbie.
