Removing Milliseconds from a time value in Power Query M | 3 Methods
Time values in Power Query can have milliseconds up to the ten-millionths of a second. Unfortunately, this level of detail blows up the size of your data models. In this video, you learn three methods to remove the milliseconds portion of a time value.
WRITTEN ARTICLE:
https://gorilla.bi/power-query/remove...
I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
TIMESTAMPS
00:00 Introduction
00:43 Displaying Milliseconds
02:25 Method 1: Formatting String
03:01 Method 2: Rounding
04:27 Method 3: Remainder
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#RemoveMilliseconds #time #m