Forum Discussion
AdministratorOverall average
Good evening, everyone,
My name is Mario, I am something new using the tool, I appreciate if you can help me with the following case:
I have a table where the integration process of a project is shown, in a column called Status it indicates me in the phase that each integration is, additionally I have a column with the beginning and end date of each process, I already made a calculated field called "Amount of days last change" to know how long each process takes.
Now what I need is to know on average how long each process takes in order to identify how many projects are above or below the average, create a measure called "average time = averagex(Amount of days last change), however what it indicates is the average that each project takes and not the general.
I appreciate the help you can give me.
Best regards.
Thank you very much for the answer, I have to mention that the proposed solution I had to vary it, it served me as follows
Calculate(average(Number of days last change), allexcept(table[project])
Best regards.
2 Replies
Syndicate_AdminThank you very much for the answer, I have to mention that the proposed solution I had to vary it, it served me as follows
Calculate(average(Number of days last change), allexcept(table[project])
Best regards.
- amitchandak
Super User
Syndicate_Admin , If you need first sum till project level and then Avg
averagex(Values(Table[Project]), calculate(Sum(Table[Amount of days last change])) )
refer if needed
