I have the source data as attached in the example. It is for a subscription service e.g. a magazine. The customer can decide to pay monthly, semi-annual or annually. The start month indicates when the amount is to be payed. For monthly fees it will be every month and for semi annually it will be the start month and start month + 6 eg march and September as in the example. I need to create a report that indicates the amount that will be collected from subscriptions each month based on this data. See example on the right. Would this be possible with DAX or do I need to expand the data in some way to be able to create this? All the amounts, periodicity etc are in one table and I of course have a standard date table.
FredrikSubscription sample.pbix (183.2 KB)