Averaging data based on a Date range in a visual

[lukas_alex]

I am looking to create a report on mark up data.  To make this report each entry has a start date, an end date, and a markup percentage.  I want to create a visual that shows the average markup month my month and the average markup is computed by averaging all the markups that active for that month (that month is within the date range).  I am thinking to do this I may have to make another table and filter the data 

Are there any other ways I may be able to do this?

I have tried this approach.  Made a new table with all the start of month dates and end of month dates and then wrote an expression to make a new colum using to try to get the average using these two colums but I get an error.  Is there a better expression to use to do this?

Date tableExpression tried

[Anonymous]

How big is the date range between each entry?

[lukas_alex]

On average 5-6 months

[Anonymous]

So do you want an entry that goes from January to June to be weighted in the average of every month from January to June? 

[lukas_alex]

yes that is what I am looking for

[Anonymous]

I don't think there's another way you could do it without creating another table. 

The January-June entry would need to somehow have the value of each month from January-June in one sliceable column but idk how that could be done.

But with another table you could easily go:

calculate(average[metric],filter([Start Date]<=[Date] && [End Date]>=[Date] 

[lukas_alex]

Would I need to create a table for each month or is there a way to do this in one table with all of the months I need

[Anonymous]

I'm sorry... My solution would just be a measure for one individual month. If there was a way for your data to be broken down into a row for every entry for every month then you could do it easily. But I'm unsure on how that could happen.