Finding the average date an event happens

[marcush]

I'm trying to create a report and find the average date range that a product of ours is sold. I think I need to be able to use a measure so that the date range can be filtered and used for any product or groups of products that we have.

We have a very seasonal business, so what I'm trying to define for our products is the average date range that __% of that product is sold between. For example, if we sell 100 of product A in a given year. I want to know what date range were the middle 80 sold (units 11-90). 

In the end I am looking to probably use a 3 year average date range. Right now I'm stuck with even finding the date range for 1 year though.

Thanks,

Marcus

[Anonymous]

@marcush,

Could you please share dummy data of your table and post expected result here?

Regards,
Lydia

[marcush]

Below is a picture of what I'm trying to do. It gets more complicated when there's multiple products in the same table. I also would like to create a 3 year average of the date range.

[marcush]

I'm trying to create a report and find the average date range that a product of ours is sold. I think I need to be able to use a measure so that the date range can be filtered and used for any product or groups of products that we have.

We have a very seasonal business, so what I'm trying to define for our products is the average date range that __% of that product is sold between. For example, if we sell 100 of product A in a given year. I want to know what date range were the middle 80 sold (units 11-90). 

In the end I am looking to probably use a 3 year average date range. Right now I'm stuck with even finding the date range for 1 year though.

Thanks,

Marcus