Forum Discussion

Lio123's avatar
Lio123
Icon for Advocate I rankAdvocate I
23 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
maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
19 days ago

Hi Lio123​,

Since you already have Customer, MRC Amount, MRC Start Date and Contract/Billable Months, I tried to come up with a solution for your question. Please find the atatched pbix file and let me know if it doesn't help.

I would create a monthly fact table with one row for every billable month of each customer contract. And then a create measure Total MRC = SUM ( FACT_MRC_MONTHLY[MRCAmount] )

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!

Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

  • Lio123's avatar
    Lio123
    Icon for Advocate I rankAdvocate I
    19 days ago

    Hi maruthisp​ ,

    Thanks for the response, however I am looking for the cumulative sum.
    If I select customer A and March, Total MRC should show 300. If I don't select the customer then it should show the cumulative of all customers. 

    Can you please help me around with this?

     

     

      • Lio123's avatar
        Lio123
        Icon for Advocate I rankAdvocate I
        18 days ago

        It worked like a charm

        Thank you so much maruthisp​