Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
LeonPouwels
Frequent Visitor

MRR calculation Start & End date filters not working

I'm looking to create an MRR measure from my invoice lines table.


My invoice lines contain a start date, end date and amount. Invoices can be montly or annually so I calculate the duration of the subscription in months. The invoice amount is then multiplied with the daily exchange rate to get Euro value and then divided by the duration to get a normalized month amount.
I want to be able to sum the monthly revenue on any given date (in a table or line chart) as long as the date on the axis is within the subscription period on the invoice line. 
Currently the result is very erractic because the Invoice table is linked to the Date table on Invoice[Created Date]. For instance on 14-02-2021 the result is 10, which is the sum of all invoices created on that date, eventhough many more are valid on that date. 

What do I need to change in my DAX or data model to get the desired result?

 

Dax:

LeonPouwels_0-1615235183974.png


Data model:

LeonPouwels_1-1615236091850.png

Wrong result:

LeonPouwels_2-1615236184141.png

 

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.