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.
How do I convert this to seconds either via measure or m. Help is much appreciated. Thanks
Solved! Go to Solution.
Hi @diskovered
format the column with Power Query (M) as duration.
With Duration.TotalSeconds([Column]), you get the seconds.
Split the column into two columns. One for minutes and one for seconds with the type number.
Then add a new column with like this
AddColNewSpeaktime = Table.AddColumn(ChangeColType, "Ø Sprechzeit", each #duration(0,0,[Ø Sprechzeit.1],[Ø Sprechzeit.2])),
AddcolNewWaittime = Table.AddColumn(AddColNewSpeaktime, "Ø Wartezeit", each #duration(0,0,[Ø Wartezeit.1],[Ø Wartezeit.2])),
#duration(0,0,0,0) need the type number
Hi @diskovered
format the column with Power Query (M) as duration.
With Duration.TotalSeconds([Column]), you get the seconds.
Could you please explain this in more detail?
I have durations in my data set that are, for example, 7 minutes 17 seconds, but powerBI auto formats the duration to be 7 hours 17 minutes 0 seconds. How can I change this?
What is your source?
Is there a "Changed Type" step?
Maybe you could insert a "Add Prefix" step before the "Changed Type" step and change the value to this format "00:07:17".
Thanks.
Got mine to work = Table.TransformColumns(#"Changed Type",{{"Value - Copy", Duration.TotalSeconds, type number}})
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |