March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello!
I have two cards both containing averages.
One is the average for response time to an inbound message. While the second card contains the average time to close/end the conversation.
These averages are based on the date range selected by the user.
However i was asked if i could remove the min/max values for each average prior to displaying the results.
Is this possible?
Heres how im calculating the initial response average
Solved! Go to Solution.
@Red_prov , Try like
AvgRespDir =
var _max = MaxX(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
var _min = Minx(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
return
AVERAGEX(filter(VALUES(Messages[ConversationID]),[ConversationInitialResponse]<> _max && [ConversationInitialResponse]<> _min ),[ConversationInitialResponse])
@Red_prov , Try like
AvgRespDir =
var _max = MaxX(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
var _min = Minx(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
return
AVERAGEX(filter(VALUES(Messages[ConversationID]),[ConversationInitialResponse]<> _max && [ConversationInitialResponse]<> _min ),[ConversationInitialResponse])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
168 | |
116 | |
63 | |
57 | |
50 |