Forum Discussion

Lio123's avatar
Lio123
Icon for Advocate I rankAdvocate I
24 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
20 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?

 

 

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
19 days ago

Hi Lio123​,
As per your requirements, I tried to create cumulative sum and please find the attached pbix file with that solution.
Best Regards,
Maruthi

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

    It worked like a charm

    Thank you so much maruthisp​