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,
i have the following table
Name Call_duration_Seconds Expected output
A 3
A 58 A=3+58+36+4=1min 41 sec(101)
A 36 =2 mins
A 4
B 11
B 18
B 4
if particular person sum of seconds, greater than or equal to 30 seconds it convert into 1 minute.
if particular person sum of seconds equal to 80 seconds(1m:20s) convert into 1 minute
if particular person sum of seconds 90(1m:30s) seconds convert into 2 minute
if particular person sum of seconds lesser than 30 seconds it convert into 0 minute.
how to create customization measure that includes above scenarioes.
My expected output as following:
is there is possible using ceiling and floor function.
Solved! Go to Solution.
You can use the ROUND function just like in Excel:
Call duration by mins = ROUND(SUM(Table[Call_duration_Seconds])/60,0)
In English: sum aggregation of seconds, divide seconds by 60 to get the decimal number of minutes (e.g. 90 seconds => 1.5 minutes), then round to the nearest whole number minute (e.g. 1.5 minutes => 2 minutes, 1.49 minutes => 1 minute)
You can use the ROUND function just like in Excel:
Call duration by mins = ROUND(SUM(Table[Call_duration_Seconds])/60,0)
In English: sum aggregation of seconds, divide seconds by 60 to get the decimal number of minutes (e.g. 90 seconds => 1.5 minutes), then round to the nearest whole number minute (e.g. 1.5 minutes => 2 minutes, 1.49 minutes => 1 minute)
Time and dates are stored internally as decimals. One day (24 hours) is a value of 1, half day (12) is 0.5 etc.
Therefore, you can use MROUND, which rounds to a multiple. The multiple you would want is 1 / 24 / 60 (one day divided by hours then minutes). Your measure could look something like:
Measure:= MROUND( SUM(Table[Call_duration_Seconds]), 1/24/60)
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |