Forum Discussion

New Member

3 years ago

Average data rather than summed

Hi, I have a calculated column of 'lead times' calcualted from the submission date and completed date. I also have a column of 'departments' When I build a pie chart or any other visual, it sums th...

Need Help

Monty03

New Member

3 years ago

Thanks for the response. The values 'lead time' is calculated as follows:

Lead Time =

AVERAGEX(

Sheet1,

IF(ISBLANK(Sheet1[Date Completed].[Date]),DATEDIFF(Sheet1[Submission Date].[Date], TODAY(),DAY),DATEDIFF(Sheet1[Submission Date].[Date],Sheet1[Date Completed].[Date],DAY)

))

This is the first time I have used DAX and I can't actually see a column of data...

I notice the box 'Data Category' is 'uncatergorized', could this have an affect?