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.
Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website
Hi @diskovered
format the column with Power Query (M) as duration.
With Duration.TotalSeconds([Column]), you get the seconds.
Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website
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".
Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website
Thanks.
Got mine to work = Table.TransformColumns(#"Changed Type",{{"Value - Copy", Duration.TotalSeconds, type number}})
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
209 | |
68 | |
63 | |
58 | |
56 |
User | Count |
---|---|
251 | |
196 | |
87 | |
72 | |
71 |