sum per time (month) using start and end date from table

Greg_Deckler

Hi

First I would like to express my appreciation for your very prompt reply. It seems that the Periodic-Billing is in line with what I need.

I do apologize for taking time to accept your solution, being very new to power BI it is taking me a while to implement. To start, I wasn’t aware the measure is based on a disconnected date table whereas my date table was connected, which produced ‘weird’ results. Which brings me to the question is there a solution where the tables are connected?  

Subsequently, I found if dates were missing in any rows the measure returned an error. Which brings me to the next question is there a solution where the rows with missing dates are not analyzed by the measure?

Thank you

Rom