Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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}})
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |