Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
They created the columns for "Enter_to_arrv_Seconds"(Response Time) and "Enter_to_disp_Seconds"(Hold Time). Just we need to convert the seconds' column to "mm: ss" format to find the average for each township. I will share the sample file here below
@FJ83 just divide that column by 86400, make the data type of the result to Date/time and format it as nn:ss.
Hi @SpartaBI
I did the changes in the column, How we can find the avg?
Since I used this column using the below DAX, however the data was not validating
@FJ83 hey, Average of that column? Average of a more complicated combination of that table that require AVERAGEX? You need to be more specific. I don't understand what you want to do.
Try to share the deisred result in the visual and what is the relevant data to get to that result.
This kind of result I'm expecting
@FJ83 every statist is represnted as a row in that table? and that tabla has a column with townships (or a dim table that filter that table with 1 to many)?
Then just created 2 measures:
Avg Hold = AVERAGE('Table'[Hold Time])
Avg Response = AVERAGE('Table'[Response Time]).
Put the township as a row or a column in a matrix and the measures as values.
No, I'm placing the average for Hold time and Response time. The result should be "00:00" , still finding problem
Thank you @FJ83
Do you want the average of each column? In this screenshot, I guess by countywide you mean for the whole data but what is P1 and P2?
if you want the average of each column then simply AVERAGE(TableName[ColumnName])
You can store this average in a variable then you can convert to mm:ss format following either my method or @SpartaBI method. This should be simple. If not please let me what average are you trying to calculate. Maybe you can present some manual calculation sample to help us understand. Thank you for patience.
P1 and P2 are called Priority, This comes from another column called PriorityKey
Create a new measure
Average Hold Time =
VAR HoldTime =
AVERAGE ( TableName[Enter_to_disp_Seconds] )
RETURN
QUOTIENT ( HoldTime, 60 ) & ":"
& MOD ( HoldTime, 60 )
Yes, I used this calculation, however, I validate the data and let you know. Thanks to @tamerj1
I agree 🙂
New Column >
Hold Time mmss =
VAR CurrentTime = 'Enter_to_disp_Seconds'[Hold Time]
RETURN
QUOTIENT ( CurrentTime, 60 ) & ":"
& MOD ( CurrentTime, 60 )
No it's not giving the right solution
@FJ83 ,
I hope the below thread would help you,
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Thanks,
Arul
We tried this one out! I used to declare the variable
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |