In today’s DAX Fridays video I will show you how to round time, prices and numbers using ROUND, ROUNDUP, ROUNDDOWN, INT, TRUNC, ODD, EVEN, MROUND, FLOOR and CEILING.

Rounding numbers, time and prices is a very useful skill as it will give you more control of your dataset and the accurancy in which your numbers are presented.

Chapters:
00:00 Intro
01:01 Round to the nearest number with ROUND
02:37 Round up to the nearest number with ROUNDUP
03:16 Round down to nearest number with ROUNDDOWN
04:11 Round down prices to the nearest integer with INT
05:00 Remove decimals from the number with TRUNC
05:48 Round up to the nearest odd number using ODD
06:11 Round down to the nearest odd number using ODD
07:43 Round prices to the nearest 0.05 of a euro cent with MROUND
08:58 Round down prices to the nearest 0.05 of a euro cent with FLOOR
09:23 Round up prices to the nearest 0.05 of a euro cent with CEILING
10:56 Round time to the nearest hour with MROUND
11:45 Round up time to the nearest 15 minutes with CEILING
12:31 Round down time to the nearest 15 minutes with FLOOR
Done!

Link to Power BI file used in the video: [ Ссылка ]

EXCEL SURVEY: [ Ссылка ]

PREVIOUS VIDEO: [ Ссылка ]
NEXT VIDEO:


Looking for a download file? Go to our Download Center: [ Ссылка ]

SUBSCRIBE to learn more about Power and Excel BI!
[ Ссылка ]

Our PLAYLISTS:
- Join our DAX Fridays! Series: [ Ссылка ]
- Power BI dashboards for beginners: [ Ссылка ]
- Power BI Tips & Tricks: [ Ссылка ]
- Power Bi and Google Analytics: [ Ссылка ]

ABOUT CURBAL:
Website: [ Ссылка ]
Contact us: [ Ссылка ]

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: [ Ссылка ]
► Facebook: [ Ссылка ]

#daxfridays #curbal #SUBSCRIBE
► Linkedin: [ Ссылка ]

свернуть