Forum Discussion

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!

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])
	)
)

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?