Forum Discussion

pgiorgi1's avatar
pgiorgi1
Frequent Visitor
4 years ago

Cannot get Dax to average.

Ok I am stumped on this one, I have an excel spreadsheet that includes these columns    AssetUUID timeHappenedUTC Title 12580 06/01/2021 3:14:14PM SOS 12580 06/01/2021 3:15:14PM Emer...
average of a measure
DATEDIFF
m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
4 years ago

pgiorgi1 Can you show us what measure did you try to get the Average?
Maybe a picture of a table and the result you currently have?

Since you already have a calculated column that seems to work, you could also try this :

AVERAGEX(
	VALUES( Table[AssetUUID] ),
	Table[YourCalculatedColumn]
)