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}})
Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.