Forum Discussion
Calculate Fees Due from Duration Range without Calendar Table Relationship
Not sure how to even begin thinking about this, hoping for some insight or suggestions. I have a table of fees/dues per customer/member called Dues (screen grab below for reference): Th...
Anonymous- Thanks to Phil_Seamark's new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence, I've been able to come up with a general solution to this type of problem. Take a look at the Quick Measure "Periodic Billing" that I posted to the Quick Measures Gallery: https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365#M148
I'm pretty sure it will do what you want.
Ashish_Mathur
Super User
Super User