Forum Discussion

Lio123's avatar
Lio123
Icon for Advocate I rankAdvocate I
17 days ago
Solved

Help with DAX

Dear Pros, Need help here I have a monthly recurring charge (MRC) from multiple customers that continues every month until the end of their contracts. I want to calculate the MRC amount for each ...
DAX
Lio123's avatar
Lio123
Icon for Advocate I rankAdvocate I
17 days ago

johnt75​ I have dim tables for customers, date and fact with customer, MRC amount, MRC billing start date and contract period. Now I want to calculate the total MRC for each month. 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
17 days ago

That sounds like a good set up. Use the fact table as the basis to generate a new fact table, linked to the same dimensions, with one entry per month per customer for the duration of the contract period.