Forum Discussion

PBI5851's avatar
PBI5851
Helper V
6 years ago
Solved

Calculate average active length

Hello, I have a table that captures for every day each and every product that is active.  Ex:  Date ProductID Date ProductID 1/1/2020 PID234 1/1/2020 PID444 1/1/2020 PID657 1/2...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    PBI5851 

     

    not very clear about your request. Could you please share the expected output for your sample data?

  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    PBI5851 

    please try this

    average = 
COUNTROWS('dateproductid')/DISTINCTCOUNT(dateproductid[ProductID])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I do something very similar with inventory, I would assume it should work the same.  Basically I want to take the average inventory of each day.

 

So I do

AVERAGEX( VALUES ( Dates[Date]), [count you want to average] )

This will average it over the relevant filter datte range