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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Cannot get Dax to average.

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


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



 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?

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 :

	VALUES( Table[AssetUUID] ),

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.