Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pgiorgi1
Frequent Visitor

Cannot get Dax to average.

Ok I am stumped on this one, I have an excel spreadsheet that includes these columns 

 

AssetUUIDtimeHappenedUTCTitle
1258006/01/2021 3:14:14PMSOS
1258006/01/2021 3:15:14PMEmergency
1258006/01/2021 3:15:45PMSOS Cancel
158008/01/2021 2:25:30AMLOGIN
1255807/01/2021 4:20:15AMSOS
1255807/01/2021 4:35:15AMSOS Cancel

 

The Goal is to look at the average time to cancel so I build a calculated column to calculate the date difference between 'SOS' and 'SOS Cancel' that looks like this 

 

Open to close = VAR SOSEmergency = CALCULATE(MAX('User Data'[timeHappenedUTC]),FILTER('User Data',[title] = "SOS"))
VAR Cancel = CALCULATE(MAX('User Data'[timeHappenedUTC]),FILTER('User Data',[title] = "SOS Cancel"))
RETURN DATEDIFF(SOSEmergency,Cancel,MINUTE

 

 

 I've been able to validate the times are accurage I have these times appearing between 1 and 57 minutes so that works. 

 

I am having a huge issue trying to get an average time from open to close: anything I do with averages show up as the highest time closed of 57 minutes, no matter what I do I seem to be missing the average.  any ideas?

1 REPLY 1
m3tr01d
Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors