Forum Discussion

Monty03's avatar
Monty03
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
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Which data type has the column Lead Time?

Try with this measure and put it in the Values field

Avg = AVERAGE(Facts38[Lead Time])
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Monty03's avatar
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?
 

 

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Please send sample data of your table Sheet1 and your expected result.