Forum Discussion

marcush's avatar
marcush
Frequent Visitor
8 years ago

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 produc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

marcush,

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

Regards,
Lydia

  • marcush's avatar
    marcush
    Frequent Visitor
    8 years ago

    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.