Skip to main content
cancel
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

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
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.

PBI_Carousel_NL_June

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.