Forum Discussion

Jazz29's avatar
Jazz29
Frequent Visitor
7 years ago

Average duration

Hi! I have a colum with duration for every car in a Parking Lot, can I calculate de duration average for every car? Thanks in advance!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    If you just want the average of all cars then its as simple as:

     

    Avg Duration := CALCULATE
(
	AVERAGE([Duration])
)

    If you are looking for the average duration of each car, and then average overall then something like this:

     

    Avg Duration by Car := CALCULATE
(
	AVERAGEX
	(
		VALUES('Data'[Vehicle Id])
		,AVERAGE('Data'[Duration])
	)
)
    • Jazz29's avatar
      Jazz29
      Frequent Visitor
      7 years ago

      Actually I apply this formula:

      AvgDuration = AVERAGEX(SUMMARIZE(Tabla1,Tabla1[Entrance date/time],"AvgDuration",sum(Tabla1[Parking duration])),[AvgDuration])
      But the SUM reset the amount when top 24 hours and start again in zero, I think the Parking duration column format is wrong, any ideas?