DAX Fridays! #32: FORMAT

In today's video we will go through FORMAT function in DAX. We will learn how to use pre-formated functions and custom functions to format numbers and dates using DAX.

Link to download the file: https://curbal.com/blog/glossary/FORM...


EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaH...

Keynotes:
01:00 Microsoft documentation on FORMAT DAX function
02:23 Pre-defined number formatting: "General Number"
03:30 Pre-defined number formatting: "Currency"
04:38 Pre-defined number formatting: "Fixed"
05:10 Pre-defined number formatting: "Standard"
06:00 Pre-defined number formatting: "Percent"
06:23 Pre-defined number formatting: "Scientific"
07:31 Format numbers without decimals
08:05 Format numbers with four decimals
08:45 Format numbers to millions and thousands
10:18 Format numbers with Leading zeros
10:51 Format numbers with one decimal
11:09 Format numbers with percent symbol
11:25 Format numbers with Scientific symbol
11:53 Pre-defined date formatting: "General Date"
12:10 Pre-defined date formatting: "Long Date"
12:40 Pre-defined date formatting: "Short Date"
12:49 Pre-defined date formatting: "Long Time"
12:50 Pre-defined date formatting: "Medium Time"
12:55 Pre-defined date formatting: "Short Time"
13:17 Format dates to return the Day number
13:22 Format dates to return Month number
13:30 Format dates to get dd-mm-yyyy format


PREVIOUS VIDEO:    • DAX Fridays! #31: Rounding Time, Pric...  
NEXT VIDEO:


Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#daxfridays #curbal #SUBSCRIBE
► Linkedin: https://goo.gl/3VW6Ky