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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
marcush
Frequent Visitor

Finding the average date an event happens

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

3 REPLIES 3
Anonymous
Not applicable

@marcush,

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

Regards,
Lydia

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.

 

Sample Data.JPG

 

marcush
Frequent Visitor

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

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.

Top Solution Authors